Microsoft Office Tutorials and References
In Depth Information
Comparing Two Ranges by Using Conditional Formatting
3. In the New Formatting Rule dialog box, click the option labeled Use a Formula to
Determine Which Cells to Format.
4. Enter this formula in the dialog box (see Figure 164-2):
=COUNTIF(NewList,A2)=0
5. Click the Format button and specify the formatting to apply when the condition is true.
A different fill color is a good choice.
6. Click OK.
Figure 164-2: Applying conditional formatting.
The cells in the NewList range use a similar conditional formatting formula.
1. Select the cells in the NewList range.
2. Choose Home
Conditional Formatting
New Rule to display the New Formatting Rule
dialog box.
3. In the New Formatting Rule dialog box, click the option labeled Use a Formula to
Determine Which Cells to Format.
4. Enter this formula in the dialog box:
=COUNTIF(OldList,D2)=0
5. Click the Format button and specify the formatting to apply when the condition is true
(a different fill color).
6. Click OK.
 
Search JabSto ::




Custom Search