Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto change cell text colour resulting from a condition
Can Excel automatically change the colour of the font in Cell by using a
conditional formula? In fact, I just want to highlights the result of a formula. Example: I want to text to in Red colour if the result is Ture, otherwise is in Blue colour. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto change cell text colour resulting from a condition
Format/ Conditional Formatting ...
-- David Biddulph "Chinaman" wrote in message ... Can Excel automatically change the colour of the font in Cell by using a conditional formula? In fact, I just want to highlights the result of a formula. Example: I want to text to in Red colour if the result is Ture, otherwise is in Blue colour. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
auto change cell text colour resulting from a condition
Cannot be done through formula only.
That's what FormatConditional Formatting is used for. Select the cell and FormatCFCell value is: type true in the dialog then formatfont to red color. As far as "otherwise" goes just format the font as blue normally. Then you will have either red or blue colored font. Gord Dibben MS Excel MVP On Wed, 13 Dec 2006 16:54:00 -0800, Chinaman wrote: Can Excel automatically change the colour of the font in Cell by using a conditional formula? In fact, I just want to highlights the result of a formula. Example: I want to text to in Red colour if the result is Ture, otherwise is in Blue colour. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy from a Cell to a text box. | Excel Worksheet Functions | |||
Change Colour on a Cell after another cell has been changed | Excel Discussion (Misc queries) | |||
Text Colour In Linked Cell | Excel Discussion (Misc queries) | |||
Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
SQL - Auto Refresh Upon Cell Value Change | Excel Worksheet Functions |