I have a spreadsheet used by mult people and we have three sections. I have
created lists for each section and did a Data / validate / list to give them
the correct options. Turns out that some have copied from one section to
another and now the lists are mixed in each section.

Is there a formula to identify the list used in a cell? or judging on the
list used, can I change the color of the cell?

I can identify the drop down's selected that are in the wrong section but
they share some names that would make it impossible to identify unless I have
a tool to identify which list it is using.

thanks