Conditional Formatting

Use conditional formatting in Excel to make data easier to read. Use the Excel conditional formatting function to better visualize data too.


  1. Open our practice workbook.
  2. Click the Challenge worksheet tab in the bottom-left of the workbook.
  3. Select cells B3:J17.
  4. Let's say you're the teacher and want to easily see all of the grades that are below passing. Apply Conditional Formatting so it Highlights Cells containing values Less Than 70 with a light red fill.
  5. Now you want to see how the grades compare to each other. Under the Conditional Formatting tab, select the Icon Set called 3 Symbols (Circled). Hint: The names of the icon sets will appear when you hover over them.
  6. Your spreadsheet should look like this:
  7. Using the Manage Rules feature, remove the light red fill, but keep the icon set.