So I have the code below working that if the cells value in column K is less than Column E *.10 then the cell in column K turns red.
It is working for every line except line 31, cell K is equal to cell E but it is still making it red, I can't figure out why.
Sub setCondFormat()
Range("K13:K42").Select
With Range("K13:K42")
.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=IF($K13="""",FALSE,IF($K13 < $E13*.1,TRUE,FALSE))"
With .FormatConditions(.FormatConditions.Count)
.SetFirstPriority
With .Interior
.PatternColorIndex = xlAutomatic
.Color = 255
.TintAndShade = 0
End With
End With
End With
End Sub
Bookmarks