Explore Contact us

What you will learn

  • This 3 hour Excel Live Online course offers an insight into using Conditional Formatting to automatically colour text, numbers and dates in a table. Incorporate rules in spreadsheets to format table content based on conditions. You connect live with our trainer.

Skills you will gain

  • Shareable Certificate Earn a Cerfiticate upon completion
  • On Demand or Face to Face Start instantly and learn at your own schedule
  • Flexible Schedule Set and maintain flexible deadlines
  • Intermediate For those with working experience or likely to have completed foundation level training  
  • English Subtitles: English

This course consists of 9 lessons

Use rules to automatically colour text and numbers.

Use colour Formatting to display only unique or duplicate table data.

Utilise the Rules Manager to manage Conditional Formatting.

Copy Conditional Formatting across files with the Format Painter.

Add Data Bars and Icon Sets for a visual representation of the size of numbers.

Use a formula to colour table rows based on a condition within it.

Format only top or bottom ranked numbers - smallest or largest.

Format only numbers that are above or below an average number.

Use the TODAY formula to automatically apply colour to approaching dates.

Show more

Frequently asked questions

Shareable on LinkedIn

You can share your Course Certificates in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.

Are you ready to begin learning exceptional new skills?

01225 308979


Find us at:
Go Courses Ltd.
Kemp House
152 - 160 City Road
United Kingdom

Registered Office:
Go Courses Ltd.
10 Laura Place
United Kingdom

View on a map

Delighted satisfaction rating