Hello -
So I have a spreadsheet that has red color to identify forecast dates across different columns. The red color is direct result of conditional formattting and manually adding red color in the said column.
I want to count number of cells highlighted in Red Color.
I found the following VBA code from ablebits website that counts cells based on either manual Red color or with Conditional format. (It can also sum based on background color as well as count / sum based on font color)

Following Code provides sum / Count Based on Manual Count 


Please Login or Register  to view this content.

Following Code provides sum / count based on Conditional Format - 

Please Login or Register  to view this content.
I need help on 2 things -
a Code that will count based on manual and conditionally formatted cells to the same color
Was also wondering, if there was a way that the code would work if filters were applied.
VBA skills are highly limited, so I need some help with it.

Thanks for reading. Appreciate the help in advance.

Sam