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