Conditional formatting - Different cell value

E

ens

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
 
D

DonCam65

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
 
Top