Hi.
I have this macro below that creates 2 different conditional formats. The problem is that the second conditional format is not displaying the color the code instructed it to.
Here is the workbook I am working with Conditional Formatting.xlsm
And here is the code that sets two different conditional formats
Sub Add_CF()
With Sheet1
With .Range("A3:N23")
.Activate
.FormatConditions.Add xlExpression, Formula1:="=AND(ISODD(ROW()),NOT(ISBLANK($K3)))"
.FormatConditions(1).Interior.Color = RGB(0, 226, 102)
End With
With .Range("A3:N23")
.Activate
.FormatConditions.Add xlExpression, Formula1:="=AND(ISODD(ROW()),NOT(ISBLANK($A3)))"
.FormatConditions(1).Interior.Color = RGB(255, 91, 91)
End With
End With
End Sub
Any help would be greatly appreciated.
Bookmarks