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