Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Excel 2003
How can the color of the text inside the cell be changed automatically when
the logical result of the formula is Yes or No? Example: using the IF function. How can I change the color of text if the result of the logical test is True and be changed into blue color if the logical result is False. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MS Excel 2003
Hi Lanz,
Try using Conditional Formatting (Format | Conditional Formatting...). If you are not familiar with this feature, see Debra Dalgleish's tutorial at: http://www.contextures.com/xlCondFormat01.html --- Regards, Norman "lanz" wrote in message ... How can the color of the text inside the cell be changed automatically when the logical result of the formula is "Yes" or "No"? Example: using the IF function. How can I change the color of text if the result of the logical test is "True" and be changed into blue color if the logical result is "False". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Very slow in opening Excel 97 file in Excel 2003 | Setting up and Configuration of Excel | |||
Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) |