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.

"ShaneDevenshire" wrote:

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.
--
Cheers,
Shane Devenshire


"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.