hello,
I can't seem to incorporate a code to highlight multiple*adjacent cells if they are blank.
Scenario:
I have 3 column E (Yes), F (No)*and G (Na),*one of cell is*tagged as "x"
All No and Na*with x are highlighted in red.
If none of the three selection is marked "x", highlight 3 cells*in blue.
I have the code below:
Sub Highlight ()
With WS.Range("$F:$G")
******* .FormatConditions.Delete
******* .FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
******* Formula1:="=""x"""
*** With .FormatConditions(1).Font
******* .Bold = True
******* .Italic = False
******* .ColorIndex = 2
*** End With
******* .FormatConditions(1).Interior.ColorIndex = 3
End Sub
Bookmarks