| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CTRL A doesn't work on a range of cells | Excel Discussion (Misc queries) | |||
| =EVALUATE("{ to work in a range of cells | Excel Worksheet Functions | |||
| Formatting cells in Excel does not work | Excel Worksheet Functions | |||
| Calculating the maximum value in a range of cells in a closed work | Excel Worksheet Functions | |||
| Formatting a range of cells doesn't work | Excel Discussion (Misc queries) | |||
Linear Mode
