| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using IF to return more than text
I would like my IF formula to output in the cell both Text and change color
of the output cell, but when I'm constructing the formula the Paintcan colors become greyed out and seems like only text is allowed. For instance if a cell is greater than another cell's value, I would like the output cell to turn red as well as say "Alert". Any way to do this? -- Matt B. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using IF to return more than text
You can change the cell's color with Conditional Format. Just use the same
condition as your If statement. -- Regards, Fred "mcb223" wrote in message ... I would like my IF formula to output in the cell both Text and change color of the output cell, but when I'm constructing the formula the Paintcan colors become greyed out and seems like only text is allowed. For instance if a cell is greater than another cell's value, I would like the output cell to turn red as well as say "Alert". Any way to do this? -- Matt B. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using IF to return more than text
Try Conditional Formatting..........do Format ConditionalFormatting then
follow the menus..........if you need assistance, post back. Vaya con Dios, Chuck, CABGx3 "mcb223" wrote: I would like my IF formula to output in the cell both Text and change color of the output cell, but when I'm constructing the formula the Paintcan colors become greyed out and seems like only text is allowed. For instance if a cell is greater than another cell's value, I would like the output cell to turn red as well as say "Alert". Any way to do this? -- Matt B. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| Search for first instance of text & return the value | Excel Worksheet Functions | |||
| Return a block of text based on a single "short name" entry | Excel Worksheet Functions | |||
Linear Mode
