Dear All,

I've no clue about VBA in excel therefore please accept my apology in advance..... After reading a lot I think I should post my question in VBA area... Here we go..


I've applied conditional formatting in one of the column. If condition will meet then the value (in number) in column will appear in RED COLOUR.

Now at the bottom of that column I want to count how many RED COLOUR figures are appearing. Is there is any way to do that?

My values will start from O41 till O114 at O115, I want to count how many RED COLOUR figures are appearing.

Thanks in advance!!