| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating with a formula referencing other cells
Can you help me again.
How would I write the formula to change the color of a cell? =if B2= ALATAX, then make C2, background color ORANGE, if B2=CROCKER, make C2 background color PURPLE, if B2=STATE, make C2 background color BLUE. This color thing is boggling my mind. I'm learning but slowly. I've pull up several items from the help - Creating conditional formatting but I'm still confused. Would I use "MOD" ? Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for Conditional Formating - Help! | Excel Worksheet Functions | |||
| Conditional Formating a Block of Cells | Excel Discussion (Misc queries) | |||
| Formula encompassing conditional formating | Excel Worksheet Functions | |||
| how to create a conditional formula for a range of cells? | Excel Worksheet Functions | |||
| Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
Threaded Mode
