Hi all,

I am looking for a Macro that will return the Count of Each colored Cell (e.g. Yellow and Red) for both Columns for B and D.
These lists will continue to have dates added to them.
The totals can go into the tables listed in Column H......

I'm not sure if this is significant but the colors of the cells are determined by a Formula in the Conditional formatting...
List 1 - Red is determined by =$B1<TODAY(), Yellow is determined by =$B1-365<TODAY()
List 2 - Red is =$D1<TODAY(), Yellow is determine by =$D1-365<TODAY() ... Same formula, different column

Also - A formula would work for the Red, but there are no formulas that i can find to work for the Yellows...This is why a Macro may work best instead of a formula...

Book1.xlsx

Regards,
Cansa