Microsoft Excel Conditional Formatting

Conditional Formatting

Conditional Formatting

90 Mins

Conditional Formatting is the process of formatting cells based on a set condition (rule). Thus when the condition in the cell is met, the cell takes on a specific pre-defined format. This makes Conditional Formatting a good way of visualising Excel data.

Required knowledge or experience:

This session is designed for users who are familiar with using Excel and are able to create, edit and print Excel spreadsheets.


Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?
Learn how to:
  • - Apply Cell Rules
  • - Apply Top-Bottom Rules
  • - Apply Data Bars
  • - Apply Gradient Fills (Color Scales)
  • - Apply Icon Sets
  • - Create and edit your own rules
  • - Modify existing rules
  • - Define your own styles for formatting
Related courses
Run this
course at
your offices
Request a quote
which course
Which level do you need?
Take our online skills assessment
Find out more
Speak to a friendly advisor


0333 344 6630

or visit our

Online Chat