Excel 2019 Bible

Chapter 17: Using Formulas with Tables and Conditional Formatting

17

6. Click the OK button once you’ve completed choosing your formatting options.


7. Click the OK button twice to confirm your formatting rule back on the New
   Formatting Rule dialog box.

For more detail on the COUNTIF function, see Chapter 13.

Highlighting Values That Exist in List1 and List2

Sometimes, you’ll need to compare two lists and pick out only the values that exist in both

lists. Again, conditional formatting is an ideal way to present your findings. Figure 17.7

illustrates a conditional formatting exercise that compares customers from 2018 and 2019,

highlighting those customers in 2019 who are in both lists.

FIGURE 17.7

You can conditionally format the values that exist in both lists.

To build this basic formatting rule, follow these steps:

1. Select the data cells in your target range (cells E4:E28 in this example).


2. Click the Home tab of the Excel Ribbon and then select Conditional Formatting
   ➪ New Rule New Rule. This will open the New Formatting Rule dialog box shown
   in Figure 17.8.