Excel - Conditional Formatting

Conditional formatting or sparklines can highlight your most important data or show data trends. Use the Quick Analysis tool (available in Excel 2016 and Excel 2013 only) for a Live Preview to try it out.

Select the data you want to examine more closely.
Click the Quick Analysis button in the bottom-right corner of the selection.
Explore the options on the Formatting and Sparklines tabs to see how they affect your data.

Quick Analysis Formatting gallery

For example, pick a colour scale in the Formatting gallery to differentiate high, medium, and low temperatures.

Data with a color scale conditional format

4. When you like what you see, click that option.