Cidtional Formatting doesn't work across all cells in range

[Guest]

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.

 

[Gord Dibben]

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

 

[Guest]

Hi,

What version of Excel are you using and more importantly what is the
conditional format. Formula Is ... or Cell Value Is? For example is you are
using a formula this will often fail due to the incorrect use of absolute and
relative references.

 

[Guest]

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.

 

[Guest]

Thanks Shane for your input. At it happens, I was using Cell Value Is...but
not catering for the potential of value beyond 2 dec pts.

 

[Guest]

I meant I changed it to 0.009

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]

Thanks for the feedback.

Gord

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.