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€¦

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?





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 format 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€¦

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

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

Hope this helps.

Pete

Robert Albrecht wrote:
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?





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 format 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...