Font Color
 

Hey,
If my formula comes back a negative I want the font to turn red.

Thanks,
Jason


--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435
View this thread: http://www.excelforum.com/showthread...hreadid=524102

Font Color
 

Sounds like a job for Format|conditional formatting.

jwfakouri wrote:

Hey,
If my formula comes back a negative I want the font to turn red.

Thanks,
Jason

--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile: http://www.excelforum.com/member.php...o&userid=31435
View this thread: http://www.excelforum.com/showthread...hreadid=524102

--

Dave Peterson

Font Color
 

Click your formula cell, Use 'Format' 'Conditional Formatting' select
'Cell Value Is' select 'Less Than' Enter '0'
Select the format you want, OK,
Regards,
Alan.
"jwfakouri" wrote
in message ...

Hey,
If my formula comes back a negative I want the font to turn red.

Thanks,
Jason


--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile:
http://www.excelforum.com/member.php...o&userid=31435
View this thread: http://www.excelforum.com/showthread...hreadid=524102

Font Color
 

Format, Cells, number OR currency.

HTH

Gilles
"jwfakouri" wrote
in message ...

Hey,
If my formula comes back a negative I want the font to turn red.

Thanks,
Jason


--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile:
http://www.excelforum.com/member.php...o&userid=31435
View this thread: http://www.excelforum.com/showthread...hreadid=524102