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.

Thousands of templates to jump start your project

Acceptance Test Plan

Contingency Plan

Software Development Templates

Acquisition Plan

Conversion Plan

Software Requirements Specification

Action Plan

Cost Benefit Analysis

Software Testing

API Documentation

Database Design

Standard Operating Procedures (SOP)

Audience Analysis

Datasheet

Statement of Work

Availability Plan

Deployment Plan

System Administration Guide

Bill of Materials

Design Document

System Boundary

Business Case

Disaster Recovery Plan

System Design Document

Business Continuity

Disposition Plan

System Specifications

Business Plan

Documentation Plan

Technical Writing Templates

Business Process

Employee Handbook

Test Plan

Business Requirements

Error Message Guide

Training Plan

Business Rules

Expression of Interest

Transition Plan

Capacity Plan

Fact Sheet

Troubleshooting Guide

Case Study

Feasibility Study

Use Case

Change Management Plan

Functional Requirements

User Guide

Communication Plan

Grant Proposal

Verification and Validation Plan

Concept of Operations

Implementation Plan

White Papers

Concept Proposal

Installation Plan

Work Instructions

Configuration Management Plan

Interface Control Document

Software Development Templates

Acceptance Test Plan

Maintenance Plan

Software Requirements Specification

Acquisition Plan

Market Research

Software Testing

Action Plan

Marketing Plan

Standard Operating Procedures (SOP)

API Documentation

Needs Statement

Statement of Work

Audience Analysis

Operations Guide

System Administration Guide

Availability Plan

Policy Manual

System Boundary

Bill of Materials

Project Plan

System Design Document

Business Case

Proposal Manager Templates

System Specifications

Business Continuity

Proposal Template

Technical Writing Templates

Business Plan

Quality Assurance Plan

Test Plan

Business Process

Release Notes

Training Plan

Business Requirements

Request for Proposal

Transition Plan

Business Rules

Risk Management Plan

Troubleshooting Guide

Capacity Plan

Scope of Work

Use Case

Case Study

Security Plan

User Guide

Change Management Plan

Service Level Agreement (SLA)

Verification and Validation Plan

Communication Plan

Setup Guide

White Papers

Concept of Operations

Social Media Policy

Work Instructions

Concept Proposal

Contingency Plan

 

Configuration Management Plan

Conversion Plan