i would like to sum only highlighted text in a row
 

I have an excel spreadsheet with 2 different colored cells (highlights). I
am trying to count only cells of a certain color. Is this possible?

i would like to sum only highlighted text in a row
 

Chip Pearson shows how it can be done he

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

You can download the macros/UDFs involved.

Hope this helps.

Pete

On May 6, 10:18*pm, Mike wrote:
I have an excel spreadsheet with 2 different colored cells (highlights). *I
am trying to count only cells of a certain color. *Is this possible?

i would like to sum only highlighted text in a row
 

Couple of methods.

1. See Chip Pearson's site for his SumByColor function.

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

2. If your version of Excel is not older than 2003 you can find by
format then select these and see the SUM on the Status Bar.

Select your range and EditFindFormat.

Select the color pattern and Find All.

In the 'Found" dialog box hit SHIFT + down arrow.

Click on Status bar and select "SUM"

If you really mean "Count" the same methods apply.

Chjp has a CountByColor


Gord Dibben MS Excel MVP



On Tue, 6 May 2008 14:18:03 -0700, Mike wrote:

I have an excel spreadsheet with 2 different colored cells (highlights). I
am trying to count only cells of a certain color. Is this possible?