How to Count Conditionally Formatted RED Color Cells

[AK_Arun]

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

Thanks.

[#2]

@AK_Arun 

Not sure whether this can help:

https://www.ablebits.com/office-addins-blog/count-sum-by-color-excel/

[#3]

Hi Kidd,

This solution is for VBA Macro...

[#4]

Hi,

Nope. I want other solution...