Applying Conditional Formatting

Issue/Question

How can I apply conditional formatting to cells?

Environment

  • Excel 2016

Resolution

  1. Open your spreadsheet.
  2. Select the cells you want to applying conditional formatting to.
  3. Under the Home tab, click Conditional Formatting.
  4. Select the options you want.