The University of North Carolina at Chapel Hill


Excel: Conditional Formatting

What is the Excel Conditional Formatting training?

This training is a basic introduction to conditional formatting in Excel. In addition, you will learn some new ways to make your data more visually appealing and ways to make your day-to-day tasks in Excel even more effective and efficient.


What will you cover in this training?

We will cover the following topics:

  • Conditional Formatting
    • How to apply highlighting rules and top/bottom rules
    • How to apply data bars, color scales, and icon sets
    • Using a formula to create conditional formatting


Who should attend this training?

You should attend this training if you have never used conditional formatting and charts and graphs or have very limited experience. In addition, you should have some foundational knowledge of Excel, including how to write basic formulas.

Date:  5/10/2023, 10:00 AM – 
Location: Zoom Video

Register Now - Individual Registration