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
Any help would be greatly appreciated.![]()
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
Bookmarks