To use it, you create rules that determine the format of cells based on their values, such as the following monthly temperature data with cell colors tied to cell values.

You can use conditional formatting to highlight cells that contain values that meet a certain condition, or format a whole cell range and vary the exact format as the value of each cell varies.

Point to Color Scales, and then click the color scale format that you want. The top color represents larger values, the center color, if any, represents middle values, and the bottom …

If you want to correct any of the values, you can do so in the Value columns. If you want to add any additional coloring assignments, click Insert on the right, type new values, and choose …

You can create a custom list based only on a value (text, number, and date or time). You cannot create a custom list based on a format (cell color, font color, or icon).

You should see the Format Object Task Pane on the right-hand side of the Excel window. If the Series Options aren't already displayed, then click the Series Option expander button on the …

You could use color to highlight which files in the library need to be reviewed. In this example, items marked "No review required" have a green background, while files requiring a review …

The BackColor property contains a numeric expression that corresponds to the color used to fill a control's or section's interior. You can use the Color Builder to set this property by clicking the …

You have a wide variety of formatting options for your lists. You can use formats to simply make a list easier to read, or you can create rules to highlight certain list items based on values in the …

Select the edit icon to choose a highlight color. You can also adjust the font size, change the font style and add a border by selecting More styles. Conditional formatting With conditional …