Applying Conditional Formatting

Issue/Question

How can I apply conditional formatting to cells?

Environment

  • Excel

Resolution

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