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

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

regards
FSt1

"Jamie" wrote:

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)