Use Icon Set in Excel - just two arrows by Chris Menard
Posted on: 02/11/2017
Icon Sets in Excel
Use an icon set to present data in three to five categories that are distinguished by a threshold value. Each icon represents a range of values and each cell is annotated with the icon that represents that range. For example, a three-icon set uses one icon to highlight all values that are greater than or equal to 67 percent, another icon for values that are less than 67 percent and greater than or equal to 33 percent, and another icon for values that are less than 33 percent.
In the video below, I only want to use the green arrow point up for positive numbers, and the red arrow pointing down for negative numbers. I do not want to use the yellow arrow. When showing icon set arrows, the arrows appear to the left of the number. You can not display the number and the arrows will appear in the middle of the column as shown in the video below.
Other useful Conditional Formatting Videos by Chris Menard
Icon sets fall under Conditional Formatting. Below are other useful videos on Conditional Formatting in Excel.
Chris Menard
Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers.
Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.
Categories