Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automating text colour changes in Excel
How do I get the text in a cell to automatically change colour when a
particular formula or function result is achieved. E.g. logical function result "TRUE" auto text colour change to green? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automating text colour changes in Excel
This feature in XL is called "Conditional Formatting".
Look it up in the Help files, and post back if you need help. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Al" wrote in message ... How do I get the text in a cell to automatically change colour when a particular formula or function result is achieved. E.g. logical function result "TRUE" auto text colour change to green? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automating text colour changes in Excel
Click on Format/Conditional Formatting on Excel's menubar. For evaluation a
formula as TRUE, click the first combo box and pick "Formula Is" from its drop down; type your formula (with the leading equal sign) in the type in field; then click the Format button; select the Patterns tab and pick your cell color; finally, OK your way back to the worksheet. Rick "Al" wrote in message ... How do I get the text in a cell to automatically change colour when a particular formula or function result is achieved. E.g. logical function result "TRUE" auto text colour change to green? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why has Excel stopped showing colour changes to fonts & text? | Excel Discussion (Misc queries) | |||
Automating text in a cell | Excel Worksheet Functions | |||
How do I auto change text colour in excel to reflect the value ent | Excel Worksheet Functions | |||
In Excel tracked changes, how do I use a different text colour? | Excel Discussion (Misc queries) | |||
Text in Blue colour, but print in black colour | Excel Worksheet Functions |