Count colored cells?

**mlk** · 05-30-2007, 03:26 PM

Is there any way to count the number of colored cells? For example, I need to flag a record when it has 1 red cell or 3 yellow cells.

I am including data example.

Thanks, Mary-Lou

**sweep** · 05-30-2007, 03:55 PM

Hi,

I think you'll find an answer here.....

http://www.ozgrid.com/Excel/count-sum-cell-color.htm

**mlk** · 05-30-2007, 04:15 PM

Thanks, this is cool.

However, I tried this out, but it doesn't appear to work with cells that are color-filled by conditional formatting.

I tried it out by manually filling the cells with color and it worked ok, but how do I get around the conditional formatting? Any ideas?

Mary-Lou

**oldchippy** · 05-30-2007, 04:21 PM

Does this link help?

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

**dominicb** · 05-30-2007, 05:00 PM

Good evening mlk

I don't thinkOldChippy's link will give you what you want. It is extremely difficult to identify a cells colour that has been conditionally formatted, as the ColorIndex (Excel's colour identifying number) remains unchanged - you have to attempt to detect the condition and work from there. You might want to look at Chip Pearson's pages for a solution :

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

HTH

DominicB