Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
conditional formatting of cells | Excel Worksheet Functions | |||
conditional formatting 2 cells | Excel Worksheet Functions | |||
Conditional Formatting with two cells | Excel Worksheet Functions | |||
Conditional Formatting Multiple cells based on 2 cells | Excel Worksheet Functions |