Color conditional formatting

1. Select the cells you want to format.

2. Go to the Home tab, select   Conditional Formatting and choose   New Rule.

3. Choose Format only cells that contain. Input the desired conditions.

4. Select Format and go to the Fill tab. Choose the colors and effects for your data.

For more info, see Use conditional formatting to highlight information.

1. Select the cells to format.

2. Go to the Home tab, select  Conditional Formatting and choose   New Rule. or a preset formatting rule.

3. Choose a Style to use and set Type, Value, Colors and other parameters.

4. Choose Classic style for more formatting options.

For more ideas, see Highlight patterns and trends with conditional formatting.

1. Select the cells to format, go to Home and select   Conditional Formatting.

2. Choose a preset formatting rule, or select    New Rule.

3. Select a Rule Type and add the criteria for the specific type. 

4. If needed, select Format with to choose colors, and text attributes.

5. Select Done. Repeat for additional rules. 

For more info, see Use conditional formatting to highlight information.