Conditional Formatting and sum of cells

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

I have several worksheets with the following info...

Column D is highlighted with Conditional Formatting based on the results
calculated by Column C.

Now I would like to sum up all of the Worksheets into one....when I place
the Sum calculation into Column D, the conditional formatting automatically
takes over and a $ - is input in the cell, even if there is no info in the
other worksheets for that row.

Any help would be greatly appreciated.
Thanks
 
CF is not taking over and giving you the $ -

$ - in the cell means that the cell is formatted as Accounting and the value is
zero.

Assuming formula is =SUM(Sheet1:Sheet4!D10) and returns a zero then CF that
cell to a white font if zero.


Gord Dibben MS Excel MVP
 
Back
Top