Add icon sets to show which cells are acceptable, which are moderate and which need attention.
Answers
Answer:
Overview of sorting and filtering data by color and icon set
Sorting and filtering data, along with conditionally formatting data, are integral parts of data analysis and can help you answer questions such as the following:
Who has sold more than $50,000 worth of services this month?
Which products have greater than 10% revenue increases from year to year?
Who are the highest performing and lowest performing students in the freshman class?
Where are the exceptions in a summary of profits over the past five years?
What is the overall age distribution of employees?
You sort data to quickly organize your data and to find the data that you want. You filter data to display only the rows that meet criteria that you specify and hide rows that you do not want displayed, for one or more columns of data. You conditionally format data to help you visually explore and analyze data, detect critical issues, and identify patterns and trends. Together, sorting, filtering, and conditionally formatting data can help you and other people who use your spreadsheet make more effective decisions based on your data.
You can sort and filter by format, including cell color and font color, whether you have manually or conditionally formatted the cells.
This picture shows filtering and sorting based on color or icon on the Category, M/M Δ%, and Markup columns.
Conditional formatting with cell background colors and icon sets
You can also sort and filter by using an icon set that you created through a conditional format. Use an icon set to annotate and classify data into three to five categories that are separated by a threshold value. Each icon represents a range of values. For example in the following table of icon sets, 3 Arrows icon set, the green arrow that points upward represents higher values, the yellow sideways arrow represents middle values, and the red arrow that points downward represents lower values.
Table of icon sets
Table of icon sets
You can format cells by using a two-color scale, three-color scale, data bars, and icon sets; format cells that contain specific text, number, date or time values, top or bottom ranked values, above or below average, unique, or duplicate values; and create many rules and manage rules more easily.
add data bars to the cells having numeric data