Skip to main content

In-depth with Excel's Conditional Formatting

Available Until

CalCPA Webcasts

Online, OK 00000

Get Directions

2.00 Credits

Member Price $69

Non-Member Price $89

Overview

The conditional formatting feature of Excel allows you to format a cell based on its value. In this session, we’ll quickly get warmed up by covering the basics and then look in-depth at its more useful capabilities, including using a formula to define the formatting rule, using icon sets to create alerts and filtering for duplicates. Presented in Excel for Windows. (Please note: Items presented may not be available in all Excel versions, including Excel for Mac, iPad or web.) The webcast was originally broadcast on June 1, 2016. Note: There is a minimum passing rate of 70% for this course.

Highlights

  • Conditional formatting basics
  • Conditional formatting icon sets
  • Conditional formatting formulas

    Prerequisites

    None

    Designed For

    Accountants using Excel for Windows.

    Objectives

  • Identify the feature in Excel that allows you to format a cell based on its value.
  • Recall the steps for conditionally formatting and filtering duplicate values.
  • Determine the steps that create an alert with icon sets.

    Preparation

    None

  • Non-Member Price $89

    Member Price $69