EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Excel Tools Excel Icon Sets
Secondary Sidebar
Excel Functions
  • Excel Tools
    • Excel Shortcut Redo
    • Reduce Excel File Size
    • Quick Analysis in Excel
    • Goal Seek in Excel
    • Compare Two Lists in Excel
    • Excel Quick Analysis
    • Estimate Template in Excel
    • Pivot Table Count Unique
    • CSV Files into Excel
    • Excel Business Plan Template
    • Excel Export to PDF
    • Free Excel Template
    • Excel Repair
    • Color in Excel
    • Form Controls in Excel
    • Timecard Template in Excel
    • How to Unhide All Sheets in Excel?
    • Power Query in Excel
    • Power View in Excel
    • XML in Excel
    • Excel Evaluate Formula
    • Examples of Excel Macros
    • Consolidation in Excel
    • Ribbon in Excel
    • Excel Conditional Formatting for Dates
    • Protect Sheet in Excel
    • Data Model in Excel
    • Pivot Table Examples
    • Pivot Table Slicer
    • Pivot Table Filter
    • Watch Window in Excel
    • Slicer in Excel
    • Print Gridlines in Excel
    • Convert Numbers to Text in Excel
    • Freeze Columns in Excel
    • Spelling Check in Excel
    • Name Box in Excel
    • Solve Equation in Excel
    • Excel Spreadsheet Examples
    • What If Analysis in Excel
    • How to Print Labels From Excel
    • Excel Named Range
    • Excel TRANSPOSE Formula
    • Excel Merge and Center
    • Excel Freeze Rows
    • HLOOKUP Formula in Excel
    • Excel Create Database
    • Excel Gridlines
    • Excel Spreadsheet Formulas
    • Excel Sort By Number
    • Excel Concatenating Columns
    • Excel AutoCorrect
    • Conditional Formatting For Blank Cells
    • Excel Icon Sets
    • Excel CTRL D
    • Excel Accounting Number Format
    • Excel Regression Analysis
    • Excel Import Data
    • Excel Freeze Panes
    • Excel Calendar
    • Excel Developer Tab
    • Excel Enable Macros
    • Excel Autosave
    • Heat Map in Excel
    • Excel Toolbar
    • Excel Error Bar
    • Excel Status Bar
    • Excel Unprotect Sheet
    • Check mark in Excel
    • Excel Column Filter
    • Excel Header and Footer
    • Excel Drawing
    • Range in Excel
    • Timeline in Excel
    • Excel Lock Formula
    • Excel Table styles
    • Insert New Worksheet in Excel
    • Excel Column Lock
    • Excel Forms for Data Entry
    • QUOTIENT in Excel
    • Excel Sorting
    • Excel Sort by color
    • Excel Data Bars
    • Excel Tool for Data Analysis
    • Excel Flash Fill
    • Excel Auto Fill
    • Excel Quick Access Toolbar
    • Excel Wrap Text
    • Excel Exponential Smoothing
    • Excel ANOVA
    • Excel Merge Two Tables
    • Excel Conditional Formatting in Pivot Table
    • Dynamic Tables in Excel
    • Excel Sort by date
    • Excel Dynamic Range
    • Record Macro in Excel
    • Two Variable Data Table in Excel
    • Merge Cells in Excel
    • One Variable Data Table in Excel
    • Excel Fill Handle
    • CheckBox in Excel
    • Excel Table
    • Excel Combo Box
    • Auto Format in Excel
    • Advanced Filter in Excel
    • Excel AutoFilter
    • Excel Data Filter
    • Excel Data Validation
    • Excel Radio Button
    • Data Table in Excel
    • Text to Columns in Excel
    • Excel List box
    • Excel Solver Tool
    • Scrollbar in Excel
  • Excel Functions (12+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (35+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (222+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL ADVANCED Training
  • EXCEL Training COURSE

Excel Icon Sets

By Karthikeyan SubburamanKarthikeyan Subburaman

Feature Image

Table of Contents

  • Icon Sets in Excel
  • How to Use Icon Sets in Excel?

Introduction to Icon Sets in Excel

Icon Sets in Excel are the sets of the different types of Icons, Shapes, Indicators, Directions, which are used for visualizing the selected values by giving them different meanings to them. Icon Sets can be accessed by the Home menu ribbon’s conditional formatting drop-down list. There we will have different categories, and all the icons there on the list have some purpose and use. We can use directions for ups and downs in data; for any indications, use Shapes and Indicators and rate anything, prefer Ratings.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

All in One Excel VBA Bundle(120+ Courses, 30+ Projects)
Basic ExcelAdvanced ExcelVBA & MacrosExcel Dashboards
Pivot TablesStatistical FunctionsFinancial FunctionsCharts & Graphs
Price
View Courses
120+ Online Courses | 30+ Projects | 500+ Hours | Verifiable Certificates | Lifetime Access
4.9 (64,858 ratings)

How to Use Icon Sets in Excel?

Using Icon Sets in Excel is easy, and we can find the icon sets in the Home menu under the Conditional Formatting styles group, which is shown by using some examples.

You can download this Icon Sets Excel Template here – Icon Sets Excel Template

Example #1

Applying Indicator Icon Sets Using Conditional Formatting

In Microsoft Excel, there are icon sets with different shapes, and Icon sets in excel are a unique kind of conditional formatting. Here in this example, we will see how to use indicator icon sets in Excel using conditional formatting.

Consider the below example, which shows the purchase data of Nov-16 month.

Purchase Data

In this example, we will apply indicator icon sets in excel using conditional formatting, where our conditional formatting formula is as follows.

  • Green Colour Icon: If the value is greater than equal to 811.
  • Yellow Colour Icon: If the value is less than 811 and greater than equal to 250 percent.
  • Red Colour Icon: If the value is less than 250 percent.

Now in this example, we will see how to display these icon sets in excel by following the below process.

  • First, create a new column for displaying icon sets, as shown below. Then next, apply the = (equal) sign in I2 and select the G2 cell to get the value in the I2 cell for applying conditional formatting.

Applying Conditional Formatting

  • Drag down the formula to all cells so that we will then get the values which are shown in the below screenshot.

Icon Sets in Excel 1-3

  • Next, select the full column name Icon Set and click on Conditional Formatting and select Icon Sets so that we will get the option to choose the icon shapes as shown below.

Icon Sets in Excel 1-4

  • Once we click on the icon sets in excel, we will get various icons like Direction, Shapes, Indicators, Rating.
  • Here in this example, we will choose the flag icon set indicators to display the output.
  • In icon sets at the bottom, we can find “More rules”, where we can apply conditional formatting over here.

Icon Sets in Excel 1-5

  • On top of that, we can see various format rules. Please select the first format rule Format all cells based on their values.
  • We can see the format style, Icon style, and Icon to be displayed in the above dialogue box. Now apply the conditional formatting as below so that we will get the icon sets to be displayed.
  • Green Colour Icon: if the value is greater than equal to 811.
  • Yellow Colour Icon: if the value is less than 811 and greater than equal to 250 percent.
  • Red Colour Icon: if the value is less than 250 percent.
  • Change the icon style to Flag and Apply the values and choose the Type as Number because by default excel will take the values as a percent. We have chosen type as a number because the format rule is based on values and not on the percentage shown in the below screenshot.

Icon Sets in Excel 1-6

  • Click OK, and we will get the below output as follows.

Icon Sets in Excel 1-7

  • In the above screenshot, we can see that icon set Flag indicators are displayed based on the condition we have applied.
  • As we notice that icon sets are displayed along with the values. In order to display only the icon, we need to select the option called Show Icon Only check box.
  • Go to conditional formatting and choose icon sets so that we will get the below dialog box.

Icon Sets in Excel 1-8

  • In the above screenshot, we can see that checkbox is enabled for “Show Icon Only” to remove all the values and display the output with only selected icons set, which is shown as the output result below.

In the below result, we can see the flag icon in column I, where we have applied condition to display as Green Flag: If the value is greater than or equal to 811 and Yellow Flag: if the value is less than 811 and greater than or equal to 250 and Red Flag: if the value is less than 250.

Icon Sets in Excel 1-9

Example #2

Applying Direction Icon Sets Using Conditional Formatting

In this example for Icon sets in excel, we are going to apply Direction Icon Set in Excel by using the same condition formatting.

Consider the below example, which shows sales data value for the month of May-18. Here in this example, we are going to check which product has sold out with the highest value using the icon set conditional formatting by following the below steps.

Icon Sets in Excel 2-1

In this example, we will apply Direction icon sets (High & Low) using conditional formatting, where our conditional formatting formula is as follows.

  • Green Colour Icon: if the value is greater than equal to 45000.
  • Yellow Colour Icon: if the value is less than 45000 and greater than equal to 43000.
  • Red Colour Icon: if the value is less than 0.

Now in this example, we will see how to display these icon sets by following the below steps.

  • First, create a new column for displaying icon sets, as shown below.
  • Then apply the = (equal) sign in the I2 column and select the G2 cell to get the value in the I2 cell for applying conditional formatting.

Icon Sets in Excel 2-2

  • Drag down the formula to all cells so that we will then get the values which are shown in the below screenshot.

Icon Sets in Excel 2-3

  • Next, select the full column of Icon Sets and Click on Conditional Formatting and select icon sets so that we will get the option to choose the icon shapes as shown below.

Icon Sets in Excel 2-4

  • Once we click on the icon sets, we will get various icons like Direction, Shapes, Indicators, Rating.
  • Here in this example, we will choose the Direction icon set indicators to display the output.
  • In icon sets at the bottom, we can find More rules where we can apply conditional formatting over here.
  • Click on More Rules so that we will get the conditional formatting dialog box as follows.

Icon Sets in Excel 2-5

  • On top of that, we can see various format rules. Then select the first format rule Format all cells based on their values.
  • We can see the format style, Icon style, and icon to be displayed in the above dialogue box. Now apply the conditional formatting as below so that we will get the icon sets to be displayed.
  • Green Colour Icon: if the value is greater than equal to 45000.
  • Yellow Colour Icon: if the value is less than 45000 and greater than equal to 43000.
  • Red Colour Icon: if the value is less than 0.
  • Change the icon style to Direction icon and Apply the values and choose the type as a Number because by default excel will take the values as percent. We have chosen type as a number because the format rule is based on values and not on the percentage shown in the below screenshot.

Icon Sets in Excel 2-6

  • Click OK, and we will get the below output as follows.

Output In the above screenshot, we can see that icon set Direction indicators are displayed based on the condition we have applied.

  • As we notice that icon sets are displayed along with the values. In order to display only the icon, we need to select the option called Show Icon Only checkbox.
  • Go to conditional formatting and choose icon sets so that we will get the below dialog box.

Show only icon checkbox

  • In the above screenshot, we can see that checkbox is enabled for Show Icon Only so that it will remove all the values and display the output with only selected icons set, which is shown as the output result as follows.

In the below result, we can see the flag icon in column I where we have applied condition to display as Green: If the value is greater than or equal to 45000 and Yellow: If the value is less than 45000 and greater than or equal to 43000 and Red: if the value is less than 0.

Flag icons in column

Things to Remember

  • Icon Sets in Excel will work only if we apply correct conditional formatting.
  • While using Excel Icon Sets, apply exact formatting rules or else excel will throw an error dialog box.
  • Icon Sets are mostly used to indicate the values in a graphical manner.

Recommended Articles

This has been a guide to Icon Sets in Excel. Here we discussed using Icon Sets in Excel and practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Excel Data Bars
  2. Compare Dates in Excel
  3. Highlight Duplicates in Excel
  4. Auditing Tools in Excel
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel Training (23 Courses, 9+ Projects)4.9
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download Icon Sets Excel Template

EDUCBA

Download Icon Sets Excel Template

EDUCBA

डाउनलोड Icon Sets Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more