How many cells filled with color?

**codyaaron2** · 04-16-2009, 09:53 PM

I want to calculate how many cells are filled with color, how can

I do this?

Thanks

**NBVC** · 04-16-2009, 10:05 PM

You will need VBA user defined function for that:

See here:

http://exceltip.com/st/Count_by_colo...Excel/518.html

or here:

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

**codyaaron2** · 04-17-2009, 09:07 AM

I cant seem to figure out what number for the color red I am using in a cell.

I am trying to use the countcolor and I need to know what number to put

in the formula. Can anyone help me with this?

Thanks

**martindwilson** · 04-17-2009, 09:44 AM

red is usually ColorIndex = 3 but to make sure start recording a macro then colour in a few cells with colours you want then stop recording view the code and see what was used