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.



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

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)

Thanks!!

"FSt1" wrote:

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)

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)

Select D4 then go to

FormatConditional FormattingFormula is:

=C4<0

Format the Font to your red color.


Gord Dibben MS Excel MVP

On Thu, 17 May 2007 08:17:02 -0700, 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)