Conditional Formatting - Row colour

[Steven]

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

 

[Steven]

Sorry but this doesnt work, none of the rows change colour. Just a little for
information as well. I have around 700 rows that have information in and if
they meet the criteria I put in my original posting I want them to change
colour no matter what row number they are.

Thanks

 

[T. Valko]

Tell me the *exact* entire range of cells you want to format.

 

[Steven]

The range of the sheet is A4 to T4 all way down to A2004 to T2004.
To recap, if there is a Y in L4 i want the whole of row 4 to change to
orange. If there is a Y in L4 and P4 I wantthe whole of row 4 to turn green.
I want this to happen all way down, so if there is a Y in L100 row 100 would
turn orange and the there were Y's in L500 and P500 row 500 would turn green,
etc.

Thanks

 

[T. Valko]

Ok, this is slightly different from what you said in your original post.

Try this...

In the Name box, that little box immediately above column A and on the far
left side of the formula bar, type in the range A4:T2004 then hit ENTER.
This will select the range of interest. Cell A4 will be the active cell. The
active cell is the one cell in the selected range that is not shaded.

Goto the menu Format>Conditional Formatting

Condition 1
Select the Formula Is option
Enter this formula *exactly as shown* in the box on the right:
=AND($L4="Y",$P4="Y")
Click the Format button
Select the Patterns tab
Select a shade of GREEN
OK

Click the Add button

Condition 2
Select the Formula Is option
Enter this formula *exactly as shown* in the box on the right:
=$L4="Y"
Click the Format button
Select the Patterns tab
Select a shade of ORANGE
OK out