View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ens ens is offline
external usenet poster
 
Posts: 1
Default 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