Hi, I've recorded a macro to apply conditional formatting rules starting from row #4. Is it possible to add a loop that would repeat this until the row 254 based on values in columns B and C of the row it is applied for? (e.g. for row 5 conditional formatting will be based on $B$5 and $C$5)
Sub TEST()
'
' TEST Macro
'
'
Rows("4:4").Select
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
Formula1:="=$B$4", Formula2:="=$C$4"
Selection.FormatConditions(Selection.FormatConditions.Count).SetFirstPriority
With Selection.FormatConditions(1).Font
.Color = -1003520
.TintAndShade = 0
End With
With Selection.FormatConditions(1).Interior
.PatternColorIndex = xlAutomatic
.Color = 15773696
.TintAndShade = 0
End With
Selection.FormatConditions(1).StopIfTrue = False
End Sub
Thanks in advance!
Bookmarks