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

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

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" wrote:

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

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

--
Biff
Microsoft Excel MVP


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

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

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" wrote:

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

--
Biff
Microsoft Excel MVP


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

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

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 FormatConditional 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


--
Biff
Microsoft Excel MVP


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

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

--
Biff
Microsoft Excel MVP


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

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