Cidtional Formatting doesn't work across all cells in range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Twishlist - 26 Sep 2007 03:26 GMT

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.

Reply to this Message

Gord Dibben - 26 Sep 2007 03:34 GMT

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

>Wondering if anyone could suggest why conditional formatting won't work
>across a range of cells;
[quoted text clipped - 5 lines]
>outwhat else might be in play.
>Would very much welcome any assistance.

Reply to this Message

Twishlist - 26 Sep 2007 05:06 GMT

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.

> Could be just a case of the value being something like 0.000000012
>
[quoted text clipped - 13 lines]
> >outwhat else might be in play.
> >Would very much welcome any assistance.

Reply to this Message

Twishlist - 26 Sep 2007 05:12 GMT

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.
[quoted text clipped - 16 lines]
> > >outwhat else might be in play.
> > >Would very much welcome any assistance.

Reply to this Message

Gord Dibben - 26 Sep 2007 16:34 GMT

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.
[quoted text clipped - 16 lines]
>> >outwhat else might be in play.
>> >Would very much welcome any assistance.

Reply to this Message

ShaneDevenshire - 26 Sep 2007 04:14 GMT

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.

Signature

Cheers,
Shane Devenshire

> Wondering if anyone could suggest why conditional formatting won't work
> across a range of cells;
[quoted text clipped - 5 lines]
> outwhat else might be in play.
> Would very much welcome any assistance.

Reply to this Message

Twishlist - 26 Sep 2007 05:10 GMT

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.

> Hi,
>
[quoted text clipped - 12 lines]
> > outwhat else might be in play.
> > Would very much welcome any assistance.

Reply to this Message