How to add Traffic Lights in Excel

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). 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. How to Add Indicators, Shapes, and Ratings to an Excel spreadsheet 1. Select the cells you want to format. 2. From the Home tab, click Conditional Formatting. 3. Scroll down to Icon Sets. 4. Select the icons set you require. You can also modify the sets if you wish. More tips and tutorials: http://klariti.com/video/