Microsoft Office Tutorials and References
In Depth Information
Tip 59: Comparing Two Ranges by Using Conditional Formatting
4. Enter this formula in the dialog box (see Figure 59-2):
=COUNTIF(NewList,A2)=0
When using this technique with your own data, substitute the actual range address (or
name) for NewList, and substitute the address of the top left selected cell for A2.
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 59-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,C2)=0
When using this technique with your own data, substitute the actual range address (or
name) for OldList, and substitute the address of the top left selected cell for C2.
Search JabSto ::




Custom Search