Cidtional Formatting doesn't work across all cells in range
 

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.

Cidtional Formatting doesn't work across all cells in range
 

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.

Cidtional Formatting doesn't work across all cells in range
 

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.

Conditional Formatting doesn't work across all cells in range
 

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.

Cidtional Formatting doesn't work across all cells in range
 

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.

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.

Conditional Formatting doesn't work across all cells in range
 

Thanks for the feedback.

Gord

On Tue, 25 Sep 2007 21:06:00 -0700, 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.