Count the number of times a cell is colored with conditional formatting

[DrSues02]

What if I have logic that is different for several of the cells in the
row?

There isn't a VBA way to come up with a count for cells highlighted by
conditional formatting?

DrSues02

 

[Myrna Larson]

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.

 

[Tom Ogilvy]

You really don't have to understand Chip's code to use it.

But he wouldn't have written it if there was a built in way to determine the
color.