Count the number of times a cell is colored with conditional formatting
What if I have logic that is different for several of the cells in the
row?
You have to count the cells colored via each of your logical expressions and
add the totals together.
There isn't a VBA way to come up with a count for cells highlighted by
conditional formatting?
No, there isn't. There's a cell property that returns the interior color, but
it returns the color the cell would have if there were no conditional
formatting.
|