Aims & Objectives

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 visualizing Excel data.

Attendees should already have a good basic knowledge of Excel and must be conversant with creating basic formulas – add, subtract, divide, multiply.

What will I learn?

Conditional Formatting

  • 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

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)