From the course: Excel: Conditional Formatting for Beginners
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Use icon sets to provide strong visual emphasis
From the course: Excel: Conditional Formatting for Beginners
Use icon sets to provide strong visual emphasis
- [Instructor] On this worksheet called icons in our chapter two file, we'd like to accentuate the salaries by either accompanying them with symbols or simply showing the symbols only. And the symbols we're talking about are found under conditional formatting on the home tab and they're referred to as icon sets and quite a few of them. And we can divide our data into thirds. You can see some of the examples there, different shapes, directional indicators, ratings or fourths or fifths. And we'll get back to that definition in a minute 'cause it's not quite exact. Let's say we want to show in a general sense whether those salaries are in the top third, middle third, or bottom third. I'll use the arrows at first, three arrows right there and we see what's happening here. Now what this doesn't mean, and it's a little tricky to explain, it doesn't mean that there are an equal number of green arrows and yellow arrows and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.