Data validation to column where value is not entered but a lookup formula

[Thi_to82]

Hi,

I'm having trouble trying to add data validation messages as the column of the value is a lookup in another worksheet. so the user will not enter the value.
I essentially want to add a two message, if the value is under <$5,000 then Message 1 and stop if the value is <$10,000 the Message 2 and okay to proceed.

Would the best solution be message box macro then? and if so can somebody help me.. not very good with this?

Thanks,

Thi

 

[NotoriousPopol]

What is the purpose of your messages? Just an alert or push the user do to something? If he's not the one who entered the value, what should he do then?

 

[Thi_to82]

It's a time sheet template, so the user will enter a project code which will look up the value available in separate worksheet.I then want those messages to appear based on returned value.