• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

count colored cells based on conditional formatting

miming1986

New Member
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!
 

Attachments

  • test.xlsm
    62.5 KB · Views: 18
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)
Code:
=COUNTIFS(R2:AG2,"<"&TODAY(),$R$1:$AG$1,"<="&G2)
 

Attachments

  • miming1986-navic42046.xlsb
    57.2 KB · Views: 31
Back
Top