Excel – Conditional Formatting

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.

Session contents:

• 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

This session is 30 minutes in duration with an additional 15 minutes for a Q & A session which you are not obligated to remain for.