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. Microsoft Excel compares each amount and formats the cells accordingly.

 

Try This, Too: What does it look like if you sort the information by Date?

 

 

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