software

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

Thanks,
Jason--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile: www.excelforum.com/member.php...oamp;userid=31435
View this thread: www.excelforum.com/showthread...hreadid=524102Sounds like a job for Format|conditional formatting.

jwfakouri wrote:
gt;
gt; Hey,
gt; If my formula comes back a negative I want the font to turn red.
gt;
gt; Thanks,
gt; Jason
gt;
gt; --
gt; jwfakouri
gt; ------------------------------------------------------------------------
gt; jwfakouri's Profile: www.excelforum.com/member.php...oamp;userid=31435
gt; View this thread: www.excelforum.com/showthread...hreadid=524102

--

Dave Peterson

Click your formula cell, Use 'Format' gt; 'Conditional Formatting' gt; select
'Cell Value Is' gt; select 'Less Than' gt; Enter '0'
Select the format you want, gt; OK,
Regards,
Alan.
quot;jwfakouriquot; gt; wrote
in message ...
gt;
gt; Hey,
gt; If my formula comes back a negative I want the font to turn red.
gt;
gt; Thanks,
gt; Jason
gt;
gt;
gt; --
gt; jwfakouri
gt; ------------------------------------------------------------------------
gt; jwfakouri's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31435
gt; View this thread: www.excelforum.com/showthread...hreadid=524102
gt;
Format, Cells, number OR currency.

HTH

Gilles
quot;jwfakouriquot; gt; wrote
in message ...
gt;
gt; Hey,
gt; If my formula comes back a negative I want the font to turn red.
gt;
gt; Thanks,
gt; Jason
gt;
gt;
gt; --
gt; jwfakouri
gt; ------------------------------------------------------------------------
gt; jwfakouri's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31435
gt; View this thread: www.excelforum.com/showthread...hreadid=524102
gt;