Excel – Conditional Formatting

Date/Time: Wednesday, 28th September 2022 - 11:00 - 11:45
Location: Online, , ,
Available Spaces: 17
Contact Details: Paul Atwell: paul.atwell1@nhs.net

Description

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.

Prerequisites
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.