software

Column A has 2100 records. Column D has 1200. Who are the 900 records that
are not in quot;Dquot; and should be? I tried to to use conditional formatting with
Cell Value Is=D21201 but it says I can't use a direct reference to a
worksheet range in a conditional formatting formula. Thanks for any help.

Hi,

Select column A (i.e., A2:A2101) --gt; quot;Formatquot; --gt; quot;Conditional Formattingquot;
--gt; quot;Formula Isquot; =COUNTIF($D$2:$D$1201,quot;=quot;amp;A2)=0 --gt; format the cells as you
wish --gt; quot;OKquot;Regards,
B. R. Ramachandran

quot;Lesquot; wrote:

gt; Column A has 2100 records. Column D has 1200. Who are the 900 records that
gt; are not in quot;Dquot; and should be? I tried to to use conditional formatting with
gt; Cell Value Is=D21201 but it says I can't use a direct reference to a
gt; worksheet range in a conditional formatting formula. Thanks for any help.