Counting Satisfied Conditional Formatting

[Nubbers]

Heya guys,

I'm trying to see if one or more of my conditional formats on a spreadsheet is in effect.

I've found an extremely helpful website http://xldynamic.com/source/xld.CFCo...s.html#isitmet but as a noob to vba I'm unable to get the code to work

When I insert the code into a blank excel spreadsheet to see if it works, nothing happens. i've tried to identify if there is a port where it would show the count, but am having no luck.

Can anybody assist me in trying to understand this? Going to see if I can find the original creators email or something maybe too...

Thanks!
Nubbers

Oh here is the code that I was mainly looking at

Please Login or Register  to view this content.

[royUK]

You need to have some Conditional Formatting set up to test it.

[Nubbers]

I set up a conditional format in cell A1 that asked if A1 was not equal to B1..and if that was true then it would highlight A1 red.

Am I supposed to see a number in a certain cell...or does it just keep it internal and I would never see if it is actually counting?

[royUK]

Is there no example on Bob's site?

Hopefully you have placed the code in a Standard Module.

If you want to test the condition in a cell, type =IsCFMet(A1). This will return True or False.

To teest it in a macro try

Please Login or Register  to view this content.

[Leith Ross]

Hello Nubbers,

I think you should re-read Bob Phillip's post. Down further you will see he has code for testing if a color condition has been met. The code you have works only to test the cell value and formula conditions used in conditional formatting.

Sincerely,
Leith Ross

[Nubbers]

hmm, i'm very confused, looked at the post a bunch more times and not sure still....i think i'll leave this for another day (when I become more knowledgeable or when it becomes absolutely necessary)...Wanted to thank you guys for your help thought! It's very much appreciated!!!!


thanks again,
Nubbers