Using icon sets to provide strong visual emphasis

- [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…