Excel – Conditional Formatting

Date/Time: Tuesday, 16th November 2021 - 10:00 am - 10:45 am

Location: Online

Available Spaces: 16

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.
Please use the login form at the top of the page.