From the course: Excel 2016 Essential Training

Unlock the full course today

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

Using conditional formatting

Using conditional formatting

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Using conditional formatting

“

- Excel's Conditional Formatting feature found on the Home tab, is a great tool for highlighting data, making it stand out. As you use this feature, I'm clicking on the button right here on the Home tab, you'll see the description of it. But as you use this often, its various features spill out over across the worksheet. So if you're going to be dealing with data, it's best to move it slightly left of center on your screen. I'm going to be applying this perhaps to Column H, Column I. So I'll scroll to the right a little bit. Let's imagine that we might want these salaries to stand out in a different way. I'm selecting Column H. Now I'm not suggesting by the way that every time you use Conditional Formatting, you'll be selecting a column, but it's common to do that. We're going to change Column H. This list might grow or shrink. We want a format applied based on some conditions. It could be something simple and straightforward like highlight cell rules that are greater than. In other…

Contents