Why Is Conditional Format Failing?

  • Thread starter Thread starter bttman
  • Start date Start date
B

bttman

I am trying to revise conditional formatting of one cell whenever the
value in a different cell is changed. I am using the on_change event
for the worksheet and if the chage target is the cell of interest, then
my conditional format routine is called. The Formula1 property is
updated but I cannot get the
Range("myrange").FormatConditions(1).Interior.ColorIndex = 3 to take
effect when it is executed under the on_change event.

It works fine under the imediate window, and if I execute the same
routine independently (not called by the on_change event).

Any ideas?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 5
Excel VBA 1
Conditional Formatting Strangeness 7
Conditional formating 2
Conditional Formatting from VBA 10
More Conditional Formatting Woes 2
Programming Formula for Cond. Format yields different formula 8
Conditional Formatting Formula propogating incorrectly 2

Back
Top