Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-07-2020, 02:19 PM
macropod's Avatar
macropod macropod is offline Help to Highlight a cell that has less than 5 characters Windows 10 Help to Highlight a cell that has less than 5 characters Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


Yes, it's possible to test for specific strings. For example:
Code:
Sub Demo()
Application.ScreenUpdating = False
Dim oCell
For Each oCell In Selection.Tables(1).Range.Cells
  With oCell.Range
    If Split(.Text, vbCr)(0) = "Ltd." Then .HighlightColorIndex = wdYellow
    If Split(.Text, vbCr)(0) = "Inc." Then .HighlightColorIndex = wdYellow
  End With
Next
Application.ScreenUpdating = True
End Sub
but using Find/Replace would be more efficient:
Code:
Sub Demo()
Application.ScreenUpdating = False
Dim Rng As Range
With Selection.Tables(1)
  Set Rng = .Range
  With .Range
    With .Find
      .ClearFormatting
      .Replacement.ClearFormatting
      .Text = "[LI][tn][dc]."
      .Replacement.Text = ""
      .Forward = True
      .Wrap = wdFindStop
      .Format = False
      .MatchWildcards = True
    End With
    Do While .Find.Execute
      If .InRange(Rng) = False Then Exit Do
      With .Cells(1).Range
        If Split(.Text, vbCr)(0) = "Ltd." Then .HighlightColorIndex = wdYellow
        If Split(.Text, vbCr)(0) = "Inc." Then .HighlightColorIndex = wdYellow
      End With
      .Collapse wdCollapseEnd
    Loop
  End With
End With
Application.ScreenUpdating = True
End Sub
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
highlight cells, less than 5 characters



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help to Highlight a cell that has less than 5 characters Highlight only the characters ER when it occurs in SEVERE. norgro Word VBA 3 02-18-2013 05:14 PM
Help to Highlight a cell that has less than 5 characters How to highlight the row based on cell value? Learner7 Excel 1 12-11-2011 02:28 AM
Help to Highlight a cell that has less than 5 characters Highlight the first X number of characters 14spar15 Word 1 11-13-2011 11:17 PM
find - reading highlight - highlight all / highlight doesn't stick when saved bobk544 Word 3 04-15-2009 03:31 PM
highlight cell after checkbox flatk Word 0 01-25-2007 12:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:56 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft