Home - Information Services - Get Help - How-to-Guides - Excel 2016 - Apply Conditional Formatting

Apply Conditional Formatting

1. Select the data to which you want to apply conditional formatting.
   
   
2. On the Home tab, click Conditional Formatting, select Highlight Cells Rules, and select the desired option.
   
   
3. Specify the desired criteria and formatting.
   
   
4. Click OK.