Interactive Form

I have created a price list for a single market (Market A) that allows the user (who uses Excel 2003 version) to click on a combo box to choose between 5 commission levels. Based on the selection, the list is automatically populates with the prices.

However, I now need to create price lists for 5 more markets with the same functionality. Rather than creating separate price lists for each market, I would to make a consolidated one. In my mind, I am trying to creating a list that allows the user to first choose the market he wants by clicking on a combo box. Excel would then populate the spreadsheet based on a template (???), then the user could click on which commission level he wants based on selection from the next combo box. I cannot think of another way of doing it without doing separate lists.

Each of markets have a different color scheme, so I would use some conditional formatting to tell it to shade these rows these particular colors based on the market chosen.

I don't want to use macros or VBA, and need to do it based on Excel 2003 because some of our users don't have higher versions.

I've attached a sample of the price list. It's been stripped down to a mocked up version, so don't pay too much attention to the actual numbers.

Rysky75L9,
If I understood well, you want your list on the first sheet to change depending of the market picked by the user. Could the quantity for each product change for each market? In that case, if could be a little tricky but I'm sure it is feasible.

Different color scheme could be a problem. Excel 2003 only has 3 different conditions for conditional formatting. Would it be acceptable to have a large font title for each market?

If by quantity, you mean the width and length, yes this changes based on the product number, which is tied to a table via VLOOKUP.

Each market has the same number of choices for commission levels, the amounts will be different however because the products and pricing are different.

No, it wouldn't be acceptable to do a different font for each market, because the color scheme is a marketing tool we use.

I can't how to change the color scheme for more than 3 choices with Excel 2003 and without using macro. Can you give another example sheet with a different color scheme?

It would be the same layout on the sheet that was attached, but the market name would be different and the color. So where you see blue on the original, just say it would be green for Market B.

According to you initial request, Excel 2003 is a must which limits the conditional formatting to 3 conditions only which won't be enough for your 6 different markets. I don't know any other way to change color.

I understand, but are you able to help me out on the rest of the request?

Maybe. My schedule a quite busy but I'll see what I can do. Can you post another market price table so I can see how much is could vary from one market to another?

The layout is exactly the same for the table for each market. The only difference is the numbers, which are confidential.

Rysky75L9
I have a first draft to get you started. I can't find how to attach a file to this.

I hope this works.

Test Price List 2.xls

In my first comment in the spreadsheet I'm referring to the formula in column E but it is actualy column I. I added more columns to the left after I wrote that comment.