Help to Highlight a cell that has less than 5 characters

macropod · #1 11-07-2020, 02:53 AM

For example:

Code:

Sub Demo()
Application.ScreenUpdating = False
Dim oCell
For Each oCell In Selection.Tables(1).Range.Cells
  With oCell.Range
    If Len(.Text) > 2 Then
      If Len(.Text) < 7 Then .HighlightColorIndex = wdYellow
    End If
  End With
Next
Application.ScreenUpdating = True
End Sub

Cendrinne · #2 11-07-2020, 03:01 AM

OMG, why when you do it, it seems so logical, but when I research and try bits of pieces and try to make a script, I don't have it. Keeps giving me errors.

I hope one day to be as logical and have a found understanding to coding like you do.

Thanks a million.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Highlight only the characters ER when it occurs in SEVERE.	norgro	Word VBA	3	02-18-2013 05:14 PM
How to highlight the row based on cell value?	Learner7	Excel	1	12-11-2011 02:28 AM
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