Excel – Conditional Formatting

Date/Time: Wednesday, 14th July 2021 - 11:00 am - 11:45 am

Location: Online

Available Spaces: 21

Contact Details: Paul Atwell: paul.atwell1@nhs.net


Conditional Formatting is a great way to quickly visualise data in a spreadsheet.  This course is for those requiring an understanding of how Conditional Formatting can be applied.

Session contents:

  • What is Conditional Formatting?
  • Demonstrating preset highlighting rules
    • Highlight Cells Rules
    • Top/Bottom Rules
    • Data Bars
    • Colour Scales
    • Icon Sets
  • Creating a Conditional Formatting rule using a formula
  • Clearing existing rules
  • Highlighting an entire record

This session is 30 minutes in duration with an additional 15 minutes for a Q & A session which you are not obligated to remain for.

You need to be logged in in order to be able to register for this event.