Conditional Formatting (FULL COURSE)

Microsoft Excel cover image for the conditional formatting course

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.

The topics:

  • 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