Home-> Styles-> Conditional Formatting-> Color Scales

Use Color Scales

Try It: Format with Color Scales

Select Column H.

Go to Home-> Styles.

Go to Conditional Formatting.

Select Color Scales: You will have a short set of built-in options.

 

What Do You See? The Color Scales use two colors to indicate the Conditional Formatting. In this example, the highest value is red and the lowest is yellow. Excel compares each amount and formats the Cells accordingly.

 

Try This, Too: What does it look like if you sort the information by Data Bars? Can you read the numbers through the Cell formatting?

 

 

After each trial, select the H Column.
Go to Conditional Formatting -> Clear Rules -> From the Selected Cells.