can i set font colors in functions

[Guest]

How can I make a cell value be a different font colors based on the value of
another cell? ex: If the value of C4 is negative, then the value in D4 will
be in red. (Needs to be red font not highlighting)

 

[Guest]

Select cell D4

Go to Format--->Conditional Formatting

Then go to formula is =<C4
Then change the font to what you want in the selection that allows you to
format the text.

 

[Guest]

hi,
you can use conditional formating.
click on D4 then go Format>contitional formating
in the conditional formating box put.....
if formula is .....=IF(C4>=0,0,1)....set font color to red

regards
FSt1

 

[Guest]

Thanks!!

hi,
you can use conditional formating.
click on D4 then go Format>contitional formating
in the conditional formating box put.....
if formula is .....=IF(C4>=0,0,1)....set font color to red

regards
FSt1

 

[David Biddulph]

You don't need the IF()
Formula is .....=C4<0
set font color to red

 

[Gord Dibben]

Select D4 then go to

Format>Conditional Formatting>Formula is:

=C4<0

Format the Font to your red color.


Gord Dibben MS Excel MVP