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