Hello,

I need help in creating a formula (through conditional formatting maybe?) where, when a name/names are selected in the dropdown – those names in column E (source of the dropdown list data) will be highlighted/formatted.

The goal: So user can know not to chose that name again as it is taken…

​Hello, I need help in creating a formula (through conditional formatting maybe?) where, when a name/names are selected in the dropdown – those names in column E (source of the dropdown list data) will be highlighted/formatted. The goal: So user can know not to chose that name again as it is taken…       Read More

​