Excel Conditional Formatting Webinar

What you will learn

This 2-hour Excel webinar offers an insight into using Conditional Formatting to automatically colour text, numbers and dates in a table, incorporating rules to format content based on conditions.

Prerequisite

No previous experience of using Conditional Formatting is required before attending this webinar.

Date and time: Once you have completed purchasing a booking, we will send an email to arrange a suitable time and date for this online course, including your booking confirmation and joining instructions.

You are asked to join the meeting 5 minutes before start time to ensure a prompt start.

Can't find the course you're looking for? Please enquire about our range of virtual classroom courses.

If booking 2 people, please add the quantity in your cart.

If booking 3 or more people, get in touch for a quote.

Price: £82


If you have any questions, please complete our enquiry form.

By the end of this webinar you will know how to:

  • Use rules to automatically colour text and numbers
  • Use colour formats to display only unique or duplicate values
  • Utilise the Rules Manager to manage Conditional Formatting
  • Copy Conditional Formatting across files with the Format Painter
  • Add Data Bars and Icon Sets to gain a visual representation of values
  • Use a formula to colour table rows based on a value within it
  • Colour only top or bottom ranked numbers - smallest or largest
  • Colour only numbers that are above or below an average number
  • Use the TODAY formula to apply colour to approaching dates