Could be just a case of the value being something like 0.000000012

When formatted to 2 DP it will display as 0.00 but is not.

Increase DP and see what your actual value is.


Gord Dibben MS Excel MVP

On Tue, 25 Sep 2007 19:26:01 -0700, Twishlist
wrote:

Wondering if anyone could suggest why conditional formatting won't work
across a range of cells;
this range is formatted as currency, and its values result from a simple SUM
function. Cells either side have the same base formatting and conditional
formatting (where 0 shows as white font colour) applied, but conditional
formatting only works on some in the range, not all.
There is seemingly no difference in the formatting, so I can't figure
outwhat else might be in play.
Would very much welcome any assistance.