Conditional+Formating

On the **Home** tab, in the **Styles** group, click the arrow next to **Conditional Formatting**, and then click **Color Scales**.

Hover over the color scale icons to see a preview of the data with conditional formatting applied. In a three-color scale, the top color represents higher values, the middle color represents medium values, and the bottom color represents lower values. This example uses the Red-Yellow-Blue color scale.