View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Twishlist Twishlist is offline
external usenet poster
 
Posts: 54
Default 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.