Learn how Excel's 20 different icon sets—like directional arrows, traffic lights, buttons, and more—are displayed in color variations based on cell content.
- [Instructor] In this worksheet called Icons…you might want to make those salaries stand out…or those years of service stand out,…by using a conditional formatting option.…Suppose we look at salaries,…conditional formatting,…icon sets,…and look at the choices we have here.…Some of these will divide the data into thirds,…and I'll come back later and explain what that means,…or fourths, or fifths,…using various combinations.…Got traffic lights here.…These are actually named too by the way.…This is called traffic lights unrimmed.…
Here are rimmed traffic lights if you care.…We've got some other choices here as well too.…In varying ways we're splitting the data into thirds,…fourths, or fifths,…although that's not an exact term.…Lots of choices here to make this data stand out.…I want to start with just these three simple arrows here.…First thought is one third of the cells have green arrows,…the higher ones.…One third have yellow,…that's the middle one.…One third have red.…Well not quite.…
The numbers are analyzed,…so those cells where we see the green arrows…
Released
7/17/2017- Conditional formatting based on content
- Formatting based on formulas
- Using data bars to display length or volume
- Using color scales to display relative differences
- Highlighting PivotTable results
- Applying banded rows
Share this video
Embed this video
Video: Using icon sets to provide strong visual emphasis