If cell equals a range then display a warning message

Wawinator

Board Regular
Joined
Jan 16, 2014
Messages
51
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:

ABClist
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Watch MrExcel Video

Forum statistics

Threads
1,128,017
Messages
5,628,153
Members
416,296
Latest member
smartua

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top