I have sheets with certain cells colored by conditional formats. I'd like to count the number of cells in each column that are colored, but a VBA module I tried doesn't recognize cells colored by conditional formats. The module does work, but I'll stress that I know nothing about VBA; there were good instructions with this, which probably is the only reason I was successful in running it. So, I guess this could be a two-part question; is there a way to count the number of cells colored by conditional formats? If not, is there a way to convert these cells into "real" colors that can be counted?
Thank you.
Bookmarks