I have a sheet called
Master that contains a column of names in cells A1-A60 (e.g.
A4: Donna, etc.).
I have another sheet called
Subsheet that contains names that may or may not appear in
I want to highlight the names in
Subsheet that match names in
Master - so, in this instance, just
I'm trying conditional formatting using this formula in
But nothing is highlighting. Maybe I'm not using
MATCH correctly. I think I need to use
INDIRECT when referring to another sheet in conditional formatting.
What's the best way to accomplish this task?