Find Conditional Format Met
 

How can I use VBA to locate cells that have their CF met and changed state?

Find Conditional Format Met
 

See Cip Pearson's site fow working with CF colors and states.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP

On Sat, 20 Oct 2007 15:42:00 -0700, HamFlyer
wrote:

How can I use VBA to locate cells that have their CF met and changed state?

Find Conditional Format Met
 

This excellent article works fine for versions earlier than 12 but seems to
abort using version 12.

"Gord Dibben" wrote:

See Cip Pearson's site fow working with CF colors and states.

http://www.cpearson.com/excel/CFColors.htm


Gord Dibben MS Excel MVP

On Sat, 20 Oct 2007 15:42:00 -0700, HamFlyer
wrote:

How can I use VBA to locate cells that have their CF met and changed state?

Find Conditional Format Met
 

On Oct 20, 6:15 pm, HamFlyer
wrote:
This excellent article works fine for versions earlier than 12 but seems to
abort using version 12.

"Gord Dibben" wrote:
See Cip Pearson's site fow working with CF colors and states.

http://www.cpearson.com/excel/CFColors.htm

Gord Dibben MS Excel MVP

On Sat, 20 Oct 2007 15:42:00 -0700, HamFlyer
wrote:

How can I use VBA to locate cells that have their CF met and changed state?

You have made the assumption the OP is using colors to indicate a
state change. What if the state change is from an empty cell to non
empty, True or False, etc.?

Sincerely,
Leith Ross

Find Conditional Format Met
 

I think the OP wanted to examine all cells with conditional formatting and
examine if the conditional formatting was in effect - i.e. the conditions
were met and the conditional format formatting specified for that condition
are being displayed.
--
Regards,
Tom Ogilvy


"Leith Ross" wrote:

On Oct 20, 6:15 pm, HamFlyer
wrote:
This excellent article works fine for versions earlier than 12 but seems to
abort using version 12.

"Gord Dibben" wrote:
See Cip Pearson's site fow working with CF colors and states.

http://www.cpearson.com/excel/CFColors.htm

Gord Dibben MS Excel MVP

On Sat, 20 Oct 2007 15:42:00 -0700, HamFlyer
wrote:

How can I use VBA to locate cells that have their CF met and changed state?

You have made the assumption the OP is using colors to indicate a
state change. What if the state change is from an empty cell to non
empty, True or False, etc.?

Sincerely,
Leith Ross