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. 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
Not Enrolled
This course is currently closed

Course Includes

  • 10 Lessons
  • Course Certificate