Count a cell with particular colour

Closed
Jen - Nov 10, 2009 at 05:33 AM
epsiman Posts 307 Registration date Tuesday November 18, 2008 Status Member Last seen February 2, 2010 - Nov 10, 2009 at 11:24 AM
Hello,

I need a formula in excel to count the cells only if they have a particualr color in it. SAy if the there are 10 cells with some text in each and filled by certain colour. I want the function to count only those cells which ahve say pink clour filled in them..

Can you help me with this?

Regards,
Isha

1 reply

epsiman Posts 307 Registration date Tuesday November 18, 2008 Status Member Last seen February 2, 2010 163
Nov 10, 2009 at 11:24 AM
Hmmm, i don't think it's possible but the formula to count 10 cells in a row is =sum(C3:C11) for example.
-3