I don't know if this is the answer your looking for. You could do some
conditional formatting where if the value is negative you change the
format of the text to white so you can't see the numbers. Format --
Conditional Formatting
Cell Value is less than 0


--
jayd77
------------------------------------------------------------------------
jayd77's Profile: http://www.excelforum.com/member.php...o&userid=19048
View this thread: http://www.excelforum.com/showthread...hreadid=493225