Change Row Colour if certain criteria is met

S

Steven

Hello,

I am trying to get the rows to change colour on my spreadsheet if certain
criteria is met. The range of the spread sheet is A4 to T4 annd wal down to
A2400 to T2400.
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 in P4 I want the whole row turned to green. I want to
this to happen all way down for each row, so if L200 has a Y in it the whole
of row 200 would turn orange and if there were Y's in L3000 and P3000 the
whole of row 3000 would turn green, etc.

Thanks
 
L

Luke M

Start by selecting row 4.
Go to Format, Conditional Format.
Change first box to "Formula is"
Input:
=AND($L4="Y",$P4="Y")
Click format, go to pattern, choose green.
Click "ok"

Next, add another condition.
Change first box to "Formula is"
Input:
=$L4="Y"
Click format, go to pattern, choose orange. Click "ok".
Click "ok"

You can now use the format painter to copy these setting to your other rows!
 
S

Steven

Works great. Thanks

Luke M said:
Start by selecting row 4.
Go to Format, Conditional Format.
Change first box to "Formula is"
Input:
=AND($L4="Y",$P4="Y")
Click format, go to pattern, choose green.
Click "ok"

Next, add another condition.
Change first box to "Formula is"
Input:
=$L4="Y"
Click format, go to pattern, choose orange. Click "ok".
Click "ok"

You can now use the format painter to copy these setting to your other rows!
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top