Is there a way to count colored cells that are conditionally formatted?

[sportjunkie42]

I've got a macro that counts colored cells, however I recently edited my sheet to conditionally format the same colors but now my color count macro does not work. Suggestions?

 

[Claus Busch]

Hi,

Am Tue, 1 Jul 2014 19:17:52 -0700 (PDT) schrieb (e-mail address removed):

I've got a macro that counts colored cells, however I recently edited my sheet to conditionally format the same colors but now my color count macro does not work. Suggestions?

have a look:
http://www.cpearson.com/excel/CFColors.htm


Regards
Claus B.

 

[sportjunkie42]

Thanks for the reference!

 

[Zaidy036]

I've got a macro that counts colored cells, however I recently edited my sheet to conditionally format the same colors but now my color count macro does not work. Suggestions?

free ASAP Utilities offers that function www.asap-utilities.com