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.Colo rIndex = 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?

It works for me. Can you post your code?


"bttman" wrote in message
oups.com...
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.Colo rIndex = 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?