Alert message and special situation

  • Thread starter Thread starter notsoXLsavy
  • Start date Start date
N

notsoXLsavy

Could anybody tell me if this is possible?

My example situaton is:
C1:C5 is a list of people's names.

Cells in Column A are Data > Validation > List based on
=$C$1:$C$5 and drop down choices are made up to A50.

Due to a staff change, text is replaced at C2 with a new
person's name. Now the change reflects in all drop downs
from that point on!

Question:
When I click on any cell less than A51 in Column A that
contains the old C2 name, can an alert message tell me
that this person has left and will not appear in the drop
down current listing?

TIA
 
Hi
this would require VBA. not possible with data validation alone
 
Hi!

You can use the data validation feature to add an input
message whenever you select one of the affected cells.

Biff
 
Thanks for this information. I've thought of an
alternative solution but need help please.
What formula can I use in 'Conditional format' so every
name in Column A that does not appear in C1:C5 changes
color?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dependent drop down dynamic range formula, off sheet. 7
Enter formula that uses values from other cells 11
Excel ALERT a duplicate of the match of two cells in two different columns... please 0
Data Validation and drop-down list using IF, AND and what else? 8
SUM determined by drop-down list 9
Formatted cell column in drop down list 1
formula to return value from a matrix - I know hor and vert values 14
Data Validation List Names 2

Back
Top