Conditional Formatting and sum of cells

[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

 

[Gord Dibben]

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