Column A has 2100 records. Column D has 1200. Who are the 900 records that
are not in "D" and should be? I tried to to use conditional formatting with
Cell Value Is=D2:D1201 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) -- "Format" -- "Conditional Formatting"
-- "Formula Is" =COUNTIF($D$2:$D$1201,"="&A2)=0 -- format the cells as you
wish -- "OK"


Regards,
B. R. Ramachandran

"Les" wrote:

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