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

[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.
--
Rosenkrantz Spreadsheet Solutions
Witkopeend 24
1423 SN
Netherlands
------------------------
E: [email protected]
W: www.rosenkrantz.nl
------------------------


"MS" <[email protected]> wrote in message
news:[email protected]...
> 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


In article <[email protected]>,
"MS" <[email protected]> wrote:

> 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?

[Bob Phillips]

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

--

HTH

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


"MS" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[MS]

Thanks to all of you.

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


Br
Morten


"MS" <[email protected]> wrote in message
news:[email protected]...
> 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]

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

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

In article <[email protected]>,
"MS" <[email protected]> wrote:

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