How to add a conditional formatting key

Let’s take a look.

Here we have same worksheet we looked at previously.

That way, we can adjust the conditions for the rules using the key itself.

The first step is to create the basic layout for the key.

For this, we’ll set up a small table with three rows - one for each conditional format.

We can then add labels for each conditional format rule.

These could be anything, but let’s use Excellent, Concern, and Danger.

Now let’s add the threshold values to the table.

This will visually synchronize the key to the table.

Now each rule refers to a value in the key.

If we change the threshold for excellent to 90 for example, more scores are highlighted in green.

We now have a fully interactive table that’s synchronized with the key.

Any change we make to the key is immediately reflected in the table.