Conditional Formatting and sum of cells
 

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

Conditional Formatting and sum of cells
 

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

On Tue, 10 Jun 2008 11:09:11 -0700, Amanda
wrote:

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