Forum Discussion

Copper Contributor

Jan 29, 2024

How to Count Conditionally Formatted RED Color Cells

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.

Count Conditionally Formatted Color Cell.xlsm168 KB

Kidd_Ip
MVP
Jan 29, 2024
AK_Arun

Not sure whether this can help:

https://www.ablebits.com/office-addins-blog/count-sum-by-color-excel/
- AK_Arun
  Copper Contributor
  Jan 29, 2024
  Hi Kidd,
  
  This solution is for VBA Macro...
  - AK_Arun
    Copper Contributor
    Feb 03, 2024
    Hi,
    
    Nope. I want other solution...

Share

Resources