Count cells that contain fill colour

Was wandering if someone can help me out with a formula that counts the number of cells that contain fill colour.

Any help will be appreciated.

If it is actually fill color (and not conditional formatting), then this procedure will work:

Please Login or Register  to view this content.

HTH

Jason

Hi jasoncw,

am I right to say that your solution will need to be setup in VB or directly into the spreadsheet cell which is what Im after, also where do I fine the coding for each colour i.e red and yellow.

In the future, please be sure to use the [ CODE ] and [ / CODE ] tags around your code (without the spaces). Here is the slight amendment to your procedure that will include the result in cell C39:

Please Login or Register  to view this content.

Jason

Hi Jason,

thanks mate works a treat.

Andy