If the conditional formatting "Applies to" range address is not equal to "$O$42:$O$141" then I want to delete the conditional formatting rule. Is that possible?
If the conditional formatting "Applies to" range address is not equal to "$O$42:$O$141" then I want to delete the conditional formatting rule. Is that possible?
why not just open the CF window, look, and then delete that rule, if needed?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It's won't be intuitive for the user to know to do that. This is part of an error check before the macro is executed, so everything is sure to run properly.
You could try this:
![]()
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
That works perfectly. Thank you![]()
I'm glad... please mark the thread as solved if we are done? Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks