1. Select D2:D1950 and go to Format Conditional
Formatting.
2. Select "Formula Is" and put:
=ISNUMBER(MATCH($D2,$F$2:$F$95,0))
3. Press the "Format" radio button and format as desired.
4. OK out.
5. Repeat the process by selecting F2:F95 and using:
=ISNA(MATCH($F2,$D$2:$D$1950,0))

HTH
Jason
Atlanta, GA

-----Original Message-----
I have 2 columns of data that I am trying to compare. 1
column is a long
list cells (d2:d1950) the 2nd column (f2:f95) contains
values that may or may
not be in column d.

I've read enough posts to find the formula for if there
is a match
(=IF(COUNTIF($D$2:$D$1936,F2)0,"match","")), but rather
really what I am
looking to do is highlight the cell in column D when
there is a match and if
there is no match I'd like to hightlight those in column
f.

Any help is really really appreciated.

Also I may have several columns f, g, h all the same
charecteristics. Would
there be a way to highlight the matches in Column D when
they match up with
any cell in f, g, or h and highlight the cell in f, g or
h when there is no
match to the range in column D?

Thanks so much
David
.