Try this...

Select the range of cells. Assume this range is A1:E3
Goto the menu FormatConditional Formatting

Condition 1
Select the Formula Is option
Enter this formula in the box on the right:
=AND($D1="Y",$E1<"Y")
Click the Format button
Select the Patterns tab
Select a shade of ORANGE
OK

Click the Add button

Condition 2
Select the Formula Is option
Enter this formula in the box on the right:
=AND($D1:$E1="Y")
Click the Format button
Select the Patterns tab
Select a shade of GREEN
OK out

--
Biff
Microsoft Excel MVP


"Steven" wrote in message
...
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