Conditional Formatting doesn't work across all cells in range
I meant I changed it to 0.009
"Twishlist" wrote:
Yes, that was it, thank you... so obvious once it's pointed out. I changed
the formatting to be eq to or less than 0.09 and that did the trick.
"Gord Dibben" wrote:
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.
|