Conditional Formatting is a great way to quickly visualise data in a spreadsheet. This video is for those requiring an understanding of how Conditional Formatting can be applied.
- What is Conditional Formatting?
- Demonstrating preset highlighting rules (Highlight Cells Rules, Top/Bottom Rules, Data Bars, Colour Scales, Icon Sets)
- Creating a Conditional Formatting rule using a formula
- Clearing existing rules
- Highlighting an entire record