Businesses often compare their data to measures called key performance indicators, which can be summarized visually using conditional formats called icon sets.
- [Instructor] In the previous movie,…I showed you how to create conditional formats…both by establishing the rules…and hard coding the values inside of the rules…or by using a formula…to compare the contents of one cell…to the contents of another.…In this movie,…I will show you how to create…a different kind of conditional format…which is based on icon sets.…Depending upon how the value compares to a rule,…Excel will display…one of a set of three, four, or five icons.…
My sample file is the icon set Excel workbook…and you can find it in the chapter one folder…of your exercise files collection.…Once again, I am working with yearly hotel data…for two different room types, Cambridge and Picadilly…for 2014 and 2015.…Let's say that I want to display one of three icons.…A green light for high performance.…A yellow light for middling performance.…And a red light for unacceptable performance.…
To do that I need to create a conditional format…based on icon sets.…First I will select the cells that I want to format.…I'll select cells C3 and C4…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Managing data using Excel tables
- Managing PivotTables and PivotCharts
- Summarizing table and PivotTable data
- Defining conditional formats
- Creating sparklines
- Sketching your dashboard layout
- Creating and managing cell links
- Linking cell contents to a shape
- Linking to a PivotTable cell
- Extending your dashboard using hidden rows