Conditional Format Feedback

The Conditional Format webinars I ran in August were popular and well received- 94% feedback score.

An email I received recently is shown below.

To watch the recording and download the materials click here.

 

 

Free Excel Webinar Recording – Conditional Formatting

Feedback score 94%

My free Excel webinar for August 2018 covered Conditional Formats. Download the materials using the button below and watch the video.

Download Webinar Materials

Content applies to Excel 2010 and later versions.

This session will take you through the basics, as well as an introduction to formula-based formats.

  • Data bars
  • Creating a progress bar using a Data bar
  • Colour scales – traffic light colours
  • Amending the default settings – getting the result you want
  • Icon sets – icons can be better for colour blind people
  • Cell-based rules – make the most of built-in features
  • Working with dates automatically
  • Formula-based rules – use formulas and functions to gain total control over conditions