• 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


  • 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


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!



Active Member
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)