Conditional Formatting and sum of cells

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting with VBA 4
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
SUMCOLOR with conditional formatting not working 3
Excel conditional formatting with Weeknum 4
Conditional formatting based on the sum of two cells (Excel 2007) 1
Conditional Format Range of Cells 3
Conditional formatting 3
Excel VBA 1

Top