In-depth with Excel's Conditional Formatting

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

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.

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.