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
 

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

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel VBA 1
Conditional Formatting with VBA 4
Using Sumproduct - Excel 2003 3
SUMCOLOR with conditional formatting not working 3
Conditional Format Range of Cells 3
Numbers showing Up Centered in Cell ? 1
Conditional Format 2

Back
Top