I enter a Cost code into a cell and for all instances these cost codes are
allowed except for one. For this one exception, I want to allow the entry
but bring up a warning box to ask user to check the entry. Is this possible
in Data Validation or must I use some other way. I know I could just use and
IF, but I don't want to add another column to my worksheet.

Many thanks for any responses