How to Count Conditionally Formatted RED Color Cells

Copper Contributor

How to count conditionally formatted red color cell?


I've tried many codes but still not working...


Range Cell : D40:D70

Sample Color : K40

Count Cell : L40



3 Replies
Hi Kidd,

This solution is for VBA Macro...

Nope. I want other solution...