Depends on your data. You can also specify a format for negative
numbers separately via the Format cells command. If this is one of
your conditions, then this is an easy way to get what you want without
using VBA.

---GJC


--
gjcase
------------------------------------------------------------------------
gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
View this thread: http://www.excelforum.com/showthread...hreadid=529565