Forum Discussion
BigBrad
Oct 02, 2021Copper Contributor
Conditional formatting to highlight non-matches
I'm trying to help someone who has a legacy spreadsheet. Column A contains location information that must adhere to a pre-defined set of location names with NO exceptions (there can't even be an ...
Juliano-Petrukio
Oct 03, 2021Bronze Contributor
You just need to verify if the MATCH() formula is returning errors
Find attachment
=ISERROR(MATCH(Value,PreDefinedNames,0))