Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple validation criteria for one cell
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple validation criteria for one cell
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple validation criteria for one cell
What is VB???
"John Bundy" wrote: 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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple validation criteria for one cell
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple validation criteria for one cell
VB is (Visual Basic for Applications) which is the language that macros are
recorded in... This would require custom code that you would (in all likelyhood) have no luck in doing yourself. I might suggest using either a conditional format to highlight the cell (no explicit message but at least you would know based on the highlighting that there is an issue) or add a helper column that checks if the item entered exists in the list and displays a message to you... If you want to go the VB route you can post back and we can give you a hand writing the code... -- HTH... Jim Thomlinson "movermike" wrote: What is VB??? "John Bundy" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
Multiple functions in a cell help | New Users to Excel | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
multiple validation in a single cell | Excel Discussion (Misc queries) |