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 :
Many thanks for your help !
Patrick.
Bookmarks