Conditional Formatting

Select the cells you want to format.

On the Home tab, select   Conditional Formatting.

Select the desired options for your data.

Select the cells you want to format.

On the Home tab, select   Conditional Formatting.

Select the desired options for your data.