How to delete one conditional formatting out of several in a user friendly manner (to be used in a form)

[limah82]

Dear All,

I am trying to create a form in excel that users will fill and print. I prefer excel rather than pdf because it as some calculation forms.

I have applied some conditionnal formating including one rule to highlight the unprotected cells (to help the user identifying which fields to complete)

The users will need to print the form once finish but I would like this specific rule not to be printed.

I am trying to find the best way to allow the users to manage this task easily.

Thanks for your help

 

[Yongle]

There is a very simple way to to this (provided that nothing else conflicts with it)
Conditional formatting rules are applied in a particular sequence and we can manipulate that
Use 2 rules on the same range of cells and toggle rule priorities

METHOD
Select all the cells being formatted by CF then type MyNamedRange in the name box (the box above cell A1) and click enter
- this simply creates a named range which is easily referred to in VBA
With those same cells highlighed add another rule to set the formatting back to normal
Set fill colour to none as the CF format

Then insert the code to toggle priorities in the PDF macro

REMOVE FORMATTING BY changing priority
    With [mynamedrange]
        .FormatConditions(2).SetFirstPriority
        .FormatConditions(1).StopIfTrue = False
    End With

INSTRUCTIONS TO PRINT TO PDF GO HERE

RE-INSTATED FORMATTING
    With [mynamedrange]
        .FormatConditions(2).SetFirstPriority
        .FormatConditions(1).StopIfTrue = False
    End With

FOR INFO ONLY

 

[limah82]

Dear Yongle,

thank you very much for your help. the formula works perfectly. (I just had to set the first formatconditions stopiftrue to true rather than false