Let’s take a look.
Here we have the test score table we looked at previously.
Currently, there is one conditional formatting rule applied to all test scores in the table.
Let’s add another conditional format rule to highlight test scores that are lower than 70, in red.
As before, start by selecting the cells to format.
Then, select an appropriate item from the Conditional Formatting menu.
Now, enter 70 for the value.
We’ll use the red preset “Light Red Fill with Dark Red Text.”
Let’s add one more conditional format to highlight scores that are below 75 in yellow.
After we click OK, we see the yellow formatting take effect.
However, notice that we no longer see the red conditional format.
Notice that the rules are listed in the order of creation, with the last rule created on top.
This is the problem.
To fix this problem we need to reorder the rules into a sequence that doesn’t cause conflicts.
We can do this by moving the red conditional format into the first position.
opt for rule, and hit the Move Up button.
