Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statement
Is it possible to use an IF to change the color of the text of a cell. E.g.
I want to write "If the value is above 0, then make the text color black. If it isn't then make it red." -- joe http://www.angelfire.com/ny5/jbc33/ |
#2
|
|||
|
|||
Take a look at "Conditional Formatting" in XL Help.
In article , "joe" wrote: Is it possible to use an IF to change the color of the text of a cell. E.g. I want to write "If the value is above 0, then make the text color black. If it isn't then make it red." |
#3
|
|||
|
|||
"Conditional Formatting" is the feature you want.........highlight the cell,
then do Format ConditionalFormatting and follow the menu to set up your conditions......... Vaya con Dios, Chuck, CABGx3 "joe" wrote in message ... Is it possible to use an IF to change the color of the text of a cell. E.g. I want to write "If the value is above 0, then make the text color black. If it isn't then make it red." -- joe http://www.angelfire.com/ny5/jbc33/ |
#4
|
|||
|
|||
"JE McGimpsey" wrote in message
... Take a look at "Conditional Formatting" in XL Help. In article , "joe" wrote: Is it possible to use an IF to change the color of the text of a cell. E.g. I want to write "If the value is above 0, then make the text color black. If it isn't then make it red." Thank you! :) -- joe http://www.angelfire.com/ny5/jbc33/ |
#5
|
|||
|
|||
"CLR" wrote in message
... "Conditional Formatting" is the feature you want.........highlight the cell, then do Format ConditionalFormatting and follow the menu to set up your conditions......... Vaya con Dios, Chuck, CABGx3 "joe" wrote in message ... Is it possible to use an IF to change the color of the text of a cell. E.g. I want to write "If the value is above 0, then make the text color black. If it isn't then make it red." -- joe http://www.angelfire.com/ny5/jbc33/ Thank you, thank you! :) -- joe http://www.angelfire.com/ny5/jbc33/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |