Microsoft Excel Functions & Formulas

Use the COUNTIF function to shade matching

numbers in column B

Cells A2:A4 in Figure 10-23 contain numbers that have to be found

in column B. If values in column B match values in column A, the

cell should be marked. Use the COUNTIF function in combination

with conditional formatting to shade each cell that meets the

desired condition.

4

To shade values in column B that correspond to values in

column A:

1. Create the worksheet shown in Figure 10-23 and select

cells B1:B10.

2. From the Format menu, select Conditional Formatting.

3. Select Formula Is and type the following formula:

=COUNTIF($A$2:$A$4,B2)>=1.

4. Click Format.

5. From the Patterns tab, select a ...