Select the entire row
I want to select the entire row and change the color of the row where
the word "CASH" is in a single cell.
The following code of the macro is not working.
'
Selection.FormatConditions.Delete
Selection.FormatConditions.Add Type:=xlCellValue,
Operator:=xlEqual, _
Formula1:="=""CASH"""
Rows(FormatConditions(1)).Select
Selection.Font.ColorIndex = 45
Please guide.
|