Hi all,
I must check some conditions on a row like that:
[VBA]If Range("A1") = "x" And Range("B1") = "x" Then
Range("M1,N1,O1).Interior.ColorIndex = 3
ElseIf Range("C1") = "x" Then
Range("M1,N1,O1").Interior.ColorIndex = 5
Else: Range("M1,N1,O1").Interior.ColorIndex = 0
[/VBA]
I wouldn't like to repeat this code for each row (about 200) and changing manually cells value too!
How can I figure out with more flexibility and elegance?
Thanks
Luca