How to use Icon sets with conditional formatting

Let’s take a look.

Here we have the set of test scores we looked at previously.

Let’s explore using conditional formatting with icon sets to highlight values in the table.

Icon sets are another primary category in the Conditional Formatting menu.

Now let’s edit this rule to see how it works.

Notice there are only two options for operators: greater than, or greater than or equals to.

Let’s switch back to the three icon set and change to numbers instead of percentages.

Let’s assign green to 80 and above, and yellow to 70 and above.

Red is automatically assigned to values less than 70.

Now let’s get rid of the yellow icon all together.

Finally, let’s update the rule to show only red icons.

To make this change, we just need to choose “No cell icon” for green.

As a final step, let’s change the red circle to a red X.

Each icon used in a rule can be changed to any other icon.

We simply opt for red x from the list.