Conditional Statements

[Guest]

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 won’t
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…

 

[Guest]

When using a conditional format, can you access any data from another sheet?

Also, can you intersect two data sets?

This problem seems quite difficult, but I am sure the solution relies upon
contional formatting.

Any help to the below question?

 

[Pete_UK]

You might find dependent data validation is suitable for your initial
query - Debra Dalgleish has some notes here:

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete