Excel – Conditional Formatting

Date/Time: Wednesday, 4th January 2023 - 10:00 - 10:45
Location: Online
Available Spaces: 15
Contact Details: Paul Atwell: paul.atwell1@nhs.net


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

A good working knowledge of Excel.

Course outline

  • 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

The session will take between 30-40 minutes to complete and is followed by a Q & A which is optional to attend.

You need to be logged in in order to be able to register for this event.
Please use the login form at the top of the page.