Conditional Formatting (FULL 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
PLEASE NOTE: For the best possible viewing experience, we recommend ‘High Definition’ mode. This can be achieved by starting the video, clicking on Settings (the ‘cog’ symbol found in the bottom right hand corner of the video) and then changing the Quality to ‘1080p HD’. If not available then select the highest value.