From the course: Excel 2016: Advanced Formatting Techniques

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Create value-based formatting using data bars, color scales, and icons

Create value-based formatting using data bars, color scales, and icons

From the course: Excel 2016: Advanced Formatting Techniques

Start my 1-month free trial

Create value-based formatting using data bars, color scales, and icons

- In addition to simple formatting, making cells bold or coloring the font or the background, Conditional Formatting has some special options. Let's suppose we want some of those salaries to stand out in different ways. I'm selecting Column H. Because some of the features we're about to see will hang down over that column, I'm going to scroll to the right a bit and then activate Conditional Formatting. We've got data bars, color scales and icon sets, and each of them has a collection here of different ways to make that data stand out. Let's first take a look at gradient fill, a kind of data bar. Now as I slide over these, look at Column H, you see what's happening. Notice how the colors fade as we move to the right. We can still see the numbers for all these colors here. I think I'll use this color right here. If you make the column wider as I'm about to do, see what happens, it grows with it, you can't really have the bars not overlap the actual values when they're part of the wider…

Contents