Apr 28 2022 10:15 AM
Sheet 1 = mailing list and sheet 2 patrons served. The goal is to highlight the served patrons on the sheet 1 mailing list.
Apr 28 2022 10:24 AM
=ISNUMBER(MATCH(A1,'patrons served'!$A$1:$A$26,0))
You can try the attached file with the above rule for conditional formatting.
Apr 28 2022 10:54 AM - edited Apr 28 2022 10:55 AM
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.
Apr 28 2022 11:14 AM
=ISNUMBER(MATCH(E1,'recipients combined'!$A$1:$A$751,0))
The above rule works in the attached sheet. I changed " E1: " to " E1 ".
Apr 28 2022 11:30 AM