In Conditional format you can sepecify if the cell is greater than 0
which would then give you a true value to change the colour of the
cell.
------------------------------------------------
~~ Message posted from
http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements