Ultimate Excel Course #4 - Conditional Formatting: Make Your Data Come to Life

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
8 Lessons (37m)
    • 1. Introduction

    • 2. Conditional Formatting to Highlight Expired and Due Dates

    • 3. Using Icon Sets to Show Monthly Comparisons

    • 4. Applying Data Bars to Compare Values or Show Progress

    • 5. Managing Multiple Rules and Dealing with Conflicts

    • 6. Applying Conditional Formatting to the Entire Row

    • 7. Testing Multiple Conditions with the AND Function

    • 8. Thank You


About This Class


This class is #4 in a series called the Ultimate Excel Course.

In this class you will learn how to use Conditional Formatting to Make Your Data Come to Life.

Conditional Formatting is one of the most popular tools in Excel. It is used to automatically format (usually change colour) of cells dependent on their value. For example, change the colour of a cell if the date has passed, or if the value in the cell is larger than a specified value.

This feature can bring your spreadsheets to life. It provides clarity and people can instantly find what they need to know. 

This class will cover;

  1. Using Conditional Formatting to highlight expired and due dates.
  2. Using Icon Sets show monthly comparisons. Here the RAG arrow icons will be used to compare this month sales versus last months. 
  3. Using Data Bars to compare values and show progress towards a goal.
  4. Managing multiple Conditional Formatting rules and how to deal with conflicts.
  5. How to highlight an entire row instead of a single cell.
  6. Testing multiple conditions by embedding the AND and OR functions within our Conditional Formatting rules.

The follow-along-file.xlsx spreadsheet used during the lessons is available for download from the Project area. You can use this to follow along with me.

The class project provides some challenges to recap on what we covered during the class. Any questions, please post them in the discussion area.

Grab a coffee, enrol and let's do this.

Please note that this is class #4 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

Class #1 - Excel Formulas Made Easy - Get up to Speed with Excel Formulas Fast

Class #2 - Essential Skills for Working with Large Spreadsheets

Class #3 - Logical Functions: The Decision Making Formulas of Excel

Class #4 - Conditional Formatting: Make Your Data Come to Life

Class #5 - Lookup Functions: The Powerful VLOOKUP Function and Beyond

Class #6 - Validating and Protecting Excel Data

Class #7 - Advanced Formulas for Analysing Data

Class #8 - Excel Charts for Simple and Effective Data Presentation

Class #9 - Cleaning and Preparing Data Ready for Analysis

Class #10 - Formatting your Data Ranges as Tables for Superior Management

Class #11 - Master PivotTables for Powerful Analysis and Reporting

Class #12 - Get & Transform Data with Power Query

Class #13 - Introduction to the Data Model and PowerPivot