G
Guest
I have a worksheet that includes conditional formatting and a button that
executes a macro to clear and update a few of the cells. These cells are not
the ones with the conditional formatting. My problem/issue is that when I
execute the macro the conditional formatted cells are reset to their
pre-conditional format condition. Immediately afterwards I can enter data
into any unrelated cell and the conditional formatting takes effect.
Pressing F9 (recalculate) also would make the conditional formatting
effective. I’ve tried adding the 'application.calculate' code to the end of
the macro but it has no impact.
What am I doing, or not doing to cause the conditional formatting to act
this way?
Thanks
- Pat
executes a macro to clear and update a few of the cells. These cells are not
the ones with the conditional formatting. My problem/issue is that when I
execute the macro the conditional formatted cells are reset to their
pre-conditional format condition. Immediately afterwards I can enter data
into any unrelated cell and the conditional formatting takes effect.
Pressing F9 (recalculate) also would make the conditional formatting
effective. I’ve tried adding the 'application.calculate' code to the end of
the macro but it has no impact.
What am I doing, or not doing to cause the conditional formatting to act
this way?
Thanks
- Pat