How to Edit Conditional Formatting Rules?
Directly to concise step-by-step plan
All the rules you have created for a particular list are grouped together, allowing you to easily edit them whenever you want.
Overview of Created Conditional Formatting Rules
Go to the list you want to edit and right-click on the column header of any column. Then select 'Conditional Formatting' and click on 'Manage Rules'. In the pop-up that opens, you will see all the rules created for this list. The following information is displayed:
- Active: Use the checkbox at the front to determine whether the formatting is applied or not.
- Rule: Here you see the chosen rule description.
- Format: The chosen formatting of the field is visually displayed here.
- Apply to the rule: This applies the formatting to the entire list row. If you use many formatting rules, we recommend unchecking this option, as the screen may appear cluttered when combining rules.
- Column: This shows the column on which the formatting rule is created. The rule is also applied here unless you have selected another column under Apply Column.
- Stop if True: If a cell value meets the condition of multiple formatting rules, you can use this checkbox to ensure that only one formatting rule is applied to the cell. The formatting in the list effectively stops after the application of this formatting rule.
- Apply Column: If you enter another column here, the formatting rule will be applied to that column instead of the column on which the formatting rule is created.
Additional Explanation for the 'Stop if True' Option
This option is only relevant if multiple formatting rules apply to the same field. If a cell value meets the condition of multiple formatting rules, all these formatting rules are applied. These rules are applied in order, so the rule at the top of the list is applied first, and the rule at the bottom of the list is applied last.
Do you want only one rule to be applied? Then you can check 'Stop if True'. This stops MKG from applying formatting rules after the checked rule. All rules that are still below this rule and apply to the column are therefore ignored. For example:
- Rule 1: Numbers higher than 500 are marked green.
- Rule 2: Numbers higher than 1000 are marked yellow.
In this example, the number 1200 meets rule 1 and rule 2. If 'Stop if True' is unchecked, the cell will be yellow because that is the last applied rule. If 'Stop if True' is checked at rule 1, the cell will be green because rule 2 is then ignored.
Ways to Edit Rules
In the list of rules, you can quickly see what all the rules entail, but you can also adjust certain columns in this overview. For example, check or uncheck the available checkboxes, or adjust Column or Apply Column.
If you select a formatting rule, you can also edit it with the buttons at the top of the pop-up:
- New Rule: Use this button to create a new rule. Here you can read more about new rules.
- Edit Rule: This allows you to edit the selected rule. You get the same pop-up screen as when you create a new rule, allowing you to edit all the details of the rule.
- Duplicate rule: This copies the selected rule. If you click in the middle of the button, exactly the same rule will be created again for the same column. If you click on the small dropdown arrow on the right of the button, you can select another column to copy the rule to.
- Delete Rule: This deletes the selected rule.
- Move Up: This moves the selected rule up, causing the rule to be applied earlier.
- Move Down: This moves the selected rule down, causing the rule to be applied later.
Have you made the necessary adjustments? Then click OK or Apply to apply the edits.
|
Save as View |
Concise Step-by-Step Plan 'Editing Conditional Formatting'
| 1 | Open the list where you want to edit a formatting rule. |
| 2 | Right-click on any column header. |
| 3 | Select 'Conditional Formatting'. |
| 4 | Click on 'Manage Rules...'. |
| 5 | You will now see an overview of all the rules created for this list. Edit, for example, the conditions of the rule, the column to which the rule is applied, or the order in which your rules are applied. |
| 6 | Click OK or Apply to apply the edits. |
|
Knowledge Center | Related: |
- Published:25 Feb 2026 00:08
- Latest update:25 Feb 2026 01:08
- TypeHandleidingen
- Category
- Product
- AvailabilityOpenbaar