Counting number of cells which are "Green"

[Skybluekid]

Hi All,

I have a column that shows green when a target has been reached.

On a separate sheet, in the same workbook I have the number of days which target has been reached in the month. At present I have to uodate this manually, is there a way to automate this?

Thanks in Advance

 

[VoG]

The easiest way is to count the cells that mjeet the criteria to trigger a green cell.

Otherwise see Conditional Formatting Colors