Hello all,
I am trying to count range of cells based on conditional formatted color;
I am loading a part of the data as shown in the attached spreadsheet. I found a VBA code online that I used which works with colored cells but does not give accurate result when the cells are conditionally formatted. for example, in the attached spreadsheet, Cell D2 is formatted using condional formatting, so the value in Cell B2 should be 1 and NOT 4. Please advise on how to tweak the code such that it works with conditional format.
Code used:
Thanks
Bookmarks