Conditional Formating - =SUM Colored Cells

[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

 

[JE McGimpsey]

See

http://cpearson.com/excel/colors.htm

 

[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.

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[MS]

Thanks to all of you.

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


Br
Morten

 

[JE McGimpsey]

Check out David McRitchie's "Getting Started with Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm