A later rule cannot override the formatting already modified by a preceding rule.Conditional formatting rules are evaluated one at a time starting with the rule listed at the top.I will be using this template to demonstrate some techniques and key facts about conditional formatting, so I would recommend that you download it and experiment with it as you continue to read. The last rule adds a Progress Bar in the % Complete column. The next 3 rules highlight specific text in the Priority column. The first rule changes tasks to gray strike-through when the Done column has a check mark. The image above shows the 5 rules used in the Task Checklist Template. If you are using a template and want to figure out how the conditional formatting works, or want to delete or change rules, you will need to know a couple of things:ġ) To view the rules for selected cells, go to Home > Conditional Formatting > Rules ManagerĢ) To view ALL the rules in the entire worksheet, select "This Worksheet" from the drop-down at the top of the Rules Manager window. Vertex42 has many templates that use both simple and advanced conditional formatting techniques. How to View/Edit Conditional Formatting Rules
0 Comments
Leave a Reply. |