count colored cells based on conditional formatting

[miming1986]

Hi everyone,

I have no luck searching the internet looking how to count the number of colored cells based on conditional formatting.
Please see attached file for better understanding what I wanted to achieve.

On column O, i wanted to count the number of red cells (overdue date) on its adjacent range (R:AG) all the way down.

I would really appreciate your help. Thanks in advance!

 

[navic]

I do not understand, you added the XLSM file to the download and locked the VBE access.

Try this formula for counting colored cells (put the formula in cell O2 and copy down)

=COUNTIFS(R2:AG2,"<"&TODAY(),$R$1:$AG$1,"<="&G2)

 

[miming1986]

OMG! This is exactly what I am looking for!
A big big big thank you navic! Liked!

 

[navic]

You are welcome.
Regards