comapre two lists

[Guest]

Hi
once i did this, but now i've forgotten the formula.
I want to comapre two lists, I want to use a conditional formatting, so that
those cells that their contents doesn't exist in the other list would be
marked in color gray.
if anyone can help please! last time I remeber I used the function countif().
thanks a lot.
Mansure

 

[Frank Kabel]

Hi
if your lists are in A1:A100 and B1:B100 try:
- select A1:A100
- goto the conditional format dialog
- enter the formula
=COUNTIF($B$1:$B$100,A1)=0
- choose your format

 

[Guest]

Thank you veeeeeeeeeeeeeery much Frank.

Hi
if your lists are in A1:A100 and B1:B100 try:
- select A1:A100
- goto the conditional format dialog
- enter the formula
=COUNTIF($B$1:$B$100,A1)=0
- choose your format