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.



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