Conditional Formating - =SUM Colored Cells

M

MS

Hello.

Win XP, Office Excel 2003 SP1 Pro.

I use "Conditional Formating" to highlight some cells with color RED etc.
Is there any way to SUM all RED cells and plase the sum in an another cell?

Thanks for any help.


Br
Morten
 
S

Spreadsheet Solutions

Morten;

It depends.
If red means negative, you can "countif" the range or red cells when they
are less then 0.

If red means "because I want it to be red for some reason", you might need a
VBA macro to sum the cells.

Mark.
 
M

MS

Thanks to all of you.

But it looks a bit complicated.
I'm not an Excelexpert......


Br
Morten
 
Top