Hi there,

I need someones help please. I have been trawling the internet and trying out all the available VBA coding to count cell colors changed by a conditional format. I have tried using the VBA from C Pearson and have also tried using one from Mr Excel.

When i copy and paste the VBA code into my workbook and then use the relevant formula to pull the data out I want, instead of it counting only the red, green or amber colored cells it is counting all of them within the range irrespective of me putting "1, 2 or 3" as the criteria.

I am using MS Excel 2010, however, I have also tried doing this in MS Excel 2003.

If you are able to help and would like a copy of the workbook just let me know.

Regards

Michael