Video: How to Add Indicators, Shapes, and Ratings Automatically to Excel spreadsheets

This Excel tutorial explains how to use conditional formatting to add icons, such as progress bars, traffic lights, and ratings to a cell in Excel (with screenshots and step-by-step instructions).

Click here for Excel business, software and testing templates.

Video: Add Indicators, Shapes, and Ratings Automatically to Excel

In this video, we show how to add different types of icons to your Excel spreadsheet.

How to Add Indicators, Shapes, and Ratings Automatically to Excel

Excel has several predefined presets you can use to apply conditional formatting to your data.

They are grouped into three categories:

  • Data Bars are horizontal bars added to each cell, much like a bar graph.
  • Color Scales change the color of each cell based on its value. Each color scale uses a two- or three-color gradient.
  • Icon Sets add a specific icon to each cell based on its value.

To Add icons to an Excel spreadsheet:

  1. Select the cells you want to format.

  1. Click the icon on the lower right as shown above or on the Home tab, click Conditional Formatting.

  1. Scroll down to Icon Sets.
  2. Select the icons set you require.

In the New Formatting window, you can also modify the sets by creating new rules and changing the values of the icons.

Click here for more video tutorials.

Want More Writing Tactics?

Over 127,000 readers rely on Klariti every month. Sign up now for Ivan’s fresh writing strategies, practical advice, and resources delivered to your inbox each week.