Per attached, I would like the column that says "This column less than 15, highlight entire line from cell A to
L.". If the cell is less than 15, it will highlight the entire line A to L and then move to the next line and highlight
it IF its below 15. I want this to repeat to line 650 rather than me manually typing it up.
The code below does
this but I have to manually type in the next line everytime as well as the code being to big.
Selection.FormatConditions(1).StopIfTrue = False
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
.PatternColorIndex = xlAutomatic
.Color = 65535
.TintAndShade = 0