| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assigning Color in If Function
In Excel 2003, can I assign color to a cell using the IF function? I want to
say "If amount 40, make it red, otherwise keep it black". Can I do that with IF? If not, do you know another way? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Assigning Color in If Function
Conditional Formatting
Cell Value Is ; greater than; 40 format any color you like "Mary Fetsch" wrote: In Excel 2003, can I assign color to a cell using the IF function? I want to say "If amount 40, make it red, otherwise keep it black". Can I do that with IF? If not, do you know another way? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Assigning Color in If Function
Thanks for your quick response!
"Teethless mama" wrote: Conditional Formatting Cell Value Is ; greater than; 40 format any color you like "Mary Fetsch" wrote: In Excel 2003, can I assign color to a cell using the IF function? I want to say "If amount 40, make it red, otherwise keep it black". Can I do that with IF? If not, do you know another way? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Font Color Function | Excel Worksheet Functions | |||
| IF function for cell color | Excel Worksheet Functions | |||
| Cell Color Function? | New Users to Excel | |||
| How to put color on if function | Excel Worksheet Functions | |||
| Re-assigning weekend days in "Networkdays" Function | Excel Discussion (Misc queries) | |||
Linear Mode
