View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Myrna Larson Myrna Larson is offline
external usenet poster
 
Posts: 863
Default 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.