Conditional Formatting is a great way to quickly visualise data in a spreadsheet. This course is for those requiring an understanding of how Conditional Formatting can be applied. The topics are:
- 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
Login
Accessing this course requires a login. Please enter your credentials below!