Count color coded cells ( formatted conditionally ) in Excel 2010

Hello,
I am Excel beginner and have a deadline for this reporting which I can't get to work..

I need to count color coded cells, which are colored via condition format.
I use the VBA script below which I found on the web, but after 3 days of trying and searching how to get this work.. I need your help.

Goal: I need to have the colored cells ( RED and GREEN) counted monthly and have the result in a different sheet of the workbook.
So in my workbook attached, the monthly 'SLO Results' colors ( RED and GREEN) should be counted by month and the result is expected in 'sheet 1' in the monthly overview.

Issue: It looks like the script works..but the counting is not

This is the script :

Please Login or Register  to view this content.

Many thanks for your help !
Patrick.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new, I will do it for you today.)

What do you mean by Excel 10? There is no such version ...

You cannot directly count conditional formatting results from a UDF. If possible, count the original conditions using a COUNTIF formula, as it will be more efficient.

I meant Excel 2010.

Thank you - please update your forum profile for clarity.

Tags? Nobody has asked you to add tags.

Go to SETTINGS (top right) and then Edit Profile - change the MS Office version setting to Excel 2010.

You'd need to supply the same criteria that are being used in the conditional format.