• 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.

Counting Cells that are red

Hi

Please help me.

I tried to google this but I got errors messages I do not understand. I managed with the help of your experts I manged to tcolour cells red - using the conditional formating.
I need to count these cells. red now.

Range is B10 to P100

AND

R10 to R100

The tab is called Testing_Main

If is is poosible to add cell 05 with the "there are xx celll still red"


that would be amazing.

thanks!!!!
 

Attachments

  • SOX_Testing_Template_Generic__Final_V9.0.xlsm
    289.3 KB · Views: 5
Hi, two ways :​
  • reading each cell color via DisplayFormat to see in VBA help

  • or a direct formula evaluation using the same criteria like used within the conditional formatting …
 
Back
Top