In an adjacent cell, you could create a formula that checks the fuel
surcharge status for the selected agent, and show a message if it meets
your criteria.
If you provide details on how fuel surcharges are recorded, someone may
be able to help you with the formula.
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?
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html