I am making an excel spreadsheet that can give quotes based on the type of
vehicle chosen from a drop down box. The selection made in the drop down box
correlates with certain numbers I pulled from another sheet using VLOOKUP
function.

Now the problem I am having is with the amount of time the vehicle will be
used. I want to use a conditional statement that for a certain vehicle
selection from the drop down box, such as Limo Bus, when you input the amount
of time, a conditional statement is formatted to understand 4-hour minimum.
And with the Corporate Sedan selection, the conditional statement is
programmed to correlate a 2-hour minimum.

So, if I input 1 hour in a 2-hour minimum, either the computation wont
occur, or a red box shows up warning the user of the 2-hour minimum.

Is this possible?
Thanks for the help, very much appreciated€¦