Displays a two-color gradient or a three-color gradient in a range of cells, shading the color to represent the values in the cell, and the gradient color intelligently changes with the size of the data value. New version of Excel brings you a brand-new "levels" conditional format.
1. Select the data you want to analyze, such as the "A3:c8" cell range.
2. In the "Start" tab of the Excel ribbon, click the Conditional Formatting button in the Styles group.
3. In the conditional Formatting Drop-down menu, perform the Levels--> green-yellow-red order.
At this point, the table of the specific data in accordance with the size of the data, displayed in different colors, for the statistical summary of the data is very practical, can make people on the overall change situation at a glance.
Make the data more expressive with varying lengths of color bars
The above is a comparison of the overall table, if you only need to be able to see the size of a certain column of data, how to do? The data bar conditional format can be applied to data, and the length of the data bar represents the size of the values in the cell. By looking at a colored bar, you can easily get to know the maximum or minimum value in a column of data by eliminating the time to contrast the values individually. The specific method of operation is as follows:
(Material network)
1. Select a range of cells in the table.
2. In the "Start" tab of the Excel ribbon, click the Conditional Formatting button in the Styles group.
3. Then, execute the "Data bar"--> "Blue Data Bar" command in the pop-up drop-down menu.
At this point, the application of the "Data bar" conditional format, you can easily see the entire column of the data maximum and minimum value, do not have to go data-by-contrast to see the dazzling.