I have 2 sheets with lists of names; if any names on sheet 2 are on sheet 1 then change cell to red.

New Contributor

Sheet 1 = mailing list and sheet 2 patrons served. The goal is to highlight the served patrons on the sheet 1 mailing list.

4 Replies


=ISNUMBER(MATCH(A1,'patrons served'!$A$1:$A$26,0))

You can try the attached file with the above rule for conditional formatting. 

I put in:
=ISNUMBER(MATCH(e1:,'recipients combined'!$A$1:$A$751,0))


I get the following:
"The value you entered isn't valid. Please try again using alternative values, punctuations or symbols.


=ISNUMBER(MATCH(E1,'recipients combined'!$A$1:$A$751,0))

The above rule works in the attached sheet. I changed " E1: " to " E1 ".

@Quadruple_Pawn, Thank you so much. This worked. I truly appreciated your prompt help.