Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Merged Cell Conditional Formatting Borders | Excel Discussion (Misc queries) | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting For A Cell Other Than The One With The Form | Excel Worksheet Functions | |||
BULK Conditional Formatting - by column without going into each cell? | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) |