If cell equals a range then display a warning message

[Wawinator]

Hello,

I am an absolute noob at excel so please bear with me.

I need to create a rule in excel which will display a warning or attention message if anyone inputs specific codes from a list that I have. It is ok to input other codes but not the one in the list that I have.

for example:

A	B	C	list
			10
			20

<TBODY>
</TBODY>

In column "A", if I put 10 or 20 I want a warning message to pop. but if anything else is put nothing will happen

Also, is it possible to include another conditions in column "A" that also look at another list and display a different message?

Thank you very much for your help.

Wawinator

 

[DILIPandey]

Hi Wawinator,

See the below file:-
https://dl.dropboxusercontent.com/u/65227334/validation.xlsm

Where you can set you customize message in top of each list

Regards,
DILIPandey