Trisha V via OfficeKB.com Wrote:
ISNT THERE A WAY TO JUST FORMAT IT?....I ALREADY HAVE THIS COLUMN WITH
A
FORMULA.

Marvin P. Winterbottom wrote:
make another column with a formula:

=IF(A1<0,0,A1)


--
Message posted via http://www.officekb.com


use conditional format if cell value < than 0 then format the text
same color as background - so it seems to dissappear


--
ufo_pilot
------------------------------------------------------------------------
ufo_pilot's Profile: http://www.excelforum.com/member.php...o&userid=25972
View this thread: http://www.excelforum.com/showthread...hreadid=392504