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.