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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating with a formula referencing other cells
Select cell C2, then use CF. Select the "Formula Is" option, and use the formula
=B2="ALATAX" and set the formatting options. Then use the Add button, and do similar formatting for the other two. HTH, Bernie MS Excel MVP "taxmom" wrote in message ... 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. |
Reply |
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) |