[jlfox]

I have a cell range that consist of different colors (blue,red,yellow.
I would like to sum data in the range but only if the cell color is a
specfic color.

Example:
My cell range is F4:F100
The range name is seats
I want to sum all blue colored cells
and place the total in the L4 cell.

My problem is refering to the blue cells only.

Thanks for your help.

[Tom Ogilvy]

Chip Pearson details how to do this at:

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

Regards,
Tom Ogilvy


jlfox wrote in message
om...
I have a cell range that consist of different colors (blue,red,yellow.
I would like to sum data in the range but only if the cell color is a
specfic color.

Example:
My cell range is F4:F100
The range name is seats
I want to sum all blue colored cells
and place the total in the L4 cell.

My problem is refering to the blue cells only.

Thanks for your help.

[Chip Pearson]

See www.cpearson.com/excel/colors.htm for some VBA code to do
exactly this.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"jlfox" wrote in message
om...
I have a cell range that consist of different colors
(blue,red,yellow.
I would like to sum data in the range but only if the cell color
is a
specfic color.

Example:
My cell range is F4:F100
The range name is seats
I want to sum all blue colored cells
and place the total in the L4 cell.

My problem is refering to the blue cells only.

Thanks for your help.