Conditional Formatting

L

Les

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.
 
B

B. R.Ramachandran

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
 
Top