Conditional formatting - Different cell value
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
|