Hello,

I am trying to get excel to highlight a row in 2 seperate colours if certain
conditions are met, for example.

A B C D E
1 0 0 0 Y 0
2 0 0 0 Y Y
3 0 0 0 0 0

I want it so that if a use a Y column D only for row to turn orange. If
There is a Y in column D and column E for row to turn green. And if no Y's in
D or E for no colour to be used.

So in example above row 1 would be orange, row 2 green and row 3 would have
no colour.

Can anyone help?

Thanks