Use conditional formatting in Excel to make data easier to read. Use the Excel conditional formatting function to better visualize data too.
- Open our practice workbook.
- Click the Challenge worksheet tab in the bottom-left of the workbook.
- Select cells B3:J17.
- 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.
- 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.
- Your spreadsheet should look like this:
- Using the Manage Rules feature, remove the light red fill, but keep the icon set.