CONDITIONAL FORMATTING
Any formula, for how to have a wrong name be highlighted if it doesn't
pertain to a list of 50 different branches? List is already made up in sheet2
and the array being named "Branches". Except Data validation check of LIST.
One can after all paste value in case of a data validation too.
|