Excel – Conditional Formatting

Date/Time: Monday, 28th June 2021 - 2:00 pm - 2:45 pm

Location: Online

Available Spaces: 19

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

Description

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.