L
Little Penny
I'm trying to create a conditional format on about 150 rows in my
spreadsheet
Range("A4:L4").Select
Range("A5:L5").Select
Range("A6:L6").Select
Up to
Range("A150:L150").Select
Using these three condition
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=$M$4=""xxxxx"""
Selection.FormatConditions(1).Interior.ColorIndex = 4
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=$I$4=""yyyyy"""
Selection.FormatConditions(2).Interior.ColorIndex = 38
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=$I$4=""zzzzzzzz"""
Selection.FormatConditions(3).Interior.ColorIndex = 40
(In the condition I would use the variable count to go to next row)
I tried creating a loop with a counter but I can't get my variable to
worth in the ranges.
Any help would be greatly appreciated.
spreadsheet
Range("A4:L4").Select
Range("A5:L5").Select
Range("A6:L6").Select
Up to
Range("A150:L150").Select
Using these three condition
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=$M$4=""xxxxx"""
Selection.FormatConditions(1).Interior.ColorIndex = 4
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=$I$4=""yyyyy"""
Selection.FormatConditions(2).Interior.ColorIndex = 38
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=$I$4=""zzzzzzzz"""
Selection.FormatConditions(3).Interior.ColorIndex = 40
(In the condition I would use the variable count to go to next row)
I tried creating a loop with a counter but I can't get my variable to
worth in the ranges.
Any help would be greatly appreciated.