How can I get a count of cells in a range that are shaded a certa.
 

I have not been able to find a countif function formula that will allow me to
count cells in a range only if they have been shaded certain colors. Any
info would be greatly appreciated!

Try Chip Pearson's website

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

Duke

"Slinkeysgirl" wrote:

I have not been able to find a countif function formula that will allow me to
count cells in a range only if they have been shaded certain colors. Any
info would be greatly appreciated!

Thank you, this is exactly what I was looking for.

"Duke Carey" wrote:

Try Chip Pearson's website

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

Duke

"Slinkeysgirl" wrote:

I have not been able to find a countif function formula that will allow me to
count cells in a range only if they have been shaded certain colors. Any
info would be greatly appreciated!

Thanks for the feedback, but the credit should go to Chip

"Slinkeysgirl" wrote:

Thank you, this is exactly what I was looking for.

"Duke Carey" wrote:

Try Chip Pearson's website

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

Duke

"Slinkeysgirl" wrote:

I have not been able to find a countif function formula that will allow me to
count cells in a range only if they have been shaded certain colors. Any
info would be greatly appreciated!