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/

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."

"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/

"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/

"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/