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