0

I'm looking for a macro that will disable the conditional cell format of several specific cells.

Essentially, I have used the conditional cell format to create a merged field of 9 cells (L2:N4) that will turn red and display "ERROR" in case some entered data appears to be wrong. However, I want to give the user the ability to have a button that she can click in order to manually disable this format and display the standard "PASS" in green. This should be achieved through a CommandButton; upon click, I would like to add a confirmation, i.e. "Are you sure you want to manually override?" followed with a yes/no choice.

I then would like the CommandButton to turn into another commandbutton that can undo this change for this particular sheet, even if some other actions were taken in the meanwhile that should not be changed.

As I am totally new to VBA and only know some basics, I have no idea how to start this... can you please give me a hand with sorting this out?

Thank you very much indeed for your help, that's much appreciated.

Improve this question
2
  • 2
    Instead of a VBA/CommandButton solution, you could also just have a checkbox, linked to a cell. All you need to do is to adjust the conditional format rules to be dependent on this cell. To do this you have to provide a custom formula in the conditional highlighting settings, e.g. =AND(YourCell,SomeErrorCheck)... Commented May 28, 2013 at 14:55
  • Thank you, this works great. If you provide a proper reply I'd be happy to rate you as solved. Commented May 29, 2013 at 15:51

1 Answer 1

Reset to default
1

Instead of a VBA/CommandButton solution, you could also just have a checkbox, linked to a cell!

All you need to do is to adjust the conditional format rules to be dependent on this cell. To do this you have to provide a custom formula in the conditional highlighting settings, e.g. =AND(YourCell,SomeErrorCheck)

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

If toggling off conditional formatting is to improve performance, this answer would not accomplish that goal.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.