Define Data Bar, Color Scale, And Icon Set Conditional Formats In Excel


show more Defining data bar, color scale, and icon set conditional formats provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training show less
please wait ...

Defining data bar, color scale, and icon set conditional formats

Many business managers keep track of their company's performance using worksheets called dashboards, which presents summary information on a single worksheet. In this movie, I'll show you three types of conditional formatting: data bars, color sales, and icon sets, that you can use to format your data to help you see how your company is performing. The first of these three conditional formats is called data bars, and what they show is the relative magnitude of values using a horizontal bar within a cell that contains the value. So, for example, in these cells here, B4:B15, I'll select them, and then I'll apply a data bars conditional format.

To do that, on the Home tab of the Ribbon, I click the Conditional Formatting button, point to Data Bars, and then I can select the color and style of data bar that I want. If I were to apply a gradient fill, that fill, the color bar, starts fully solid at the left edge, and then it tails off and gets lighter as you go to the right. So,...

Defining data bar, color scale, and icon set conditional formats
Video duration: 6m 6s 6h 32m Beginner

Viewers:

Defining data bar, color scale, and icon set conditional formats provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel for Mac 2011 Essential Training

Subject:
Business
Software:
Excel for Mac
Author:
please wait ...