The bad news is that copy|paste will remove the format|conditional formatting as
well as the data|validation rules.

Maybe you could tell the users to stay away from pasting--or you could use an
adjacent cell:

=if(countif(Branches,a2)0,"","Error--Not on list")

and give it a nice bold red format.

FARAZ QURESHI wrote:

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.

--

Dave Peterson