can i set font colors in functions

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
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.
 
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
 
Thanks!!

FSt1 said:
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
Click to expand...
 
Select D4 then go to

Format>Conditional Formatting>Formula is:

=C4<0

Format the Font to your red color.


Gord Dibben MS Excel MVP
 
Back
Top