Conditional formatting - Different cell value

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ens - 16 Aug 2006 23:52 GMT

I need help in giving color to Column A cells based on the values in Column B
cells. For example:

A B
1 car y5
2 bike x3
3 toy y2
4 bird y5
5 cat x3

I want to turn the cell color yellow if any value in column B is y5 and
change the cell color yellow if any value in column B is X3. I have about
3000 values to do this for, so I want the same conditional formatting on all
of the columns.

Thanks in advance for your help

Reply to this Message

DonCam65 - 17 Aug 2006 03:31 GMT

ens

In the first cell in A (say A3)
Conditional formatting
Use 'Formula Is"
Enter =B3="x3"
Format to selected colour
Add a second condition
Use 'Formula Is'
Enter =B3="y5"
Format to same (or another colour)
OK
Now with cell A3 selected
Format paint
Select by highlighting all the cells in col A to have this formatting
When you release the mouse click it will be done - magic!
Hope this helps

Signature

Don C

> I need help in giving color to Column A cells based on the values in Column B
> cells. For example:
[quoted text clipped - 12 lines]
>
> Thanks in advance for your help

Reply to this Message