Nothing built in, you could do it in VB though
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"movermike" wrote:

In cell A1, I currently have installed a validation that gives a warning box
"this is not one of our agents" if entered data is NOT in a specified list of
agents . Can I add additional validation to cell A1 that would also give a
separate warning "agent 629 has a fuel surcharge" if a specific item in the
list IS selected?