Change Display Range Based On Change of Dropdown Values

[rich_cirillo]

Greetings

I have 3 options in a Dropdown List Box..Cold,Hot & Caustic...is it possible to achieve the following

1. if i select "CAUSTIC" from dropdown list then it shows the 7 steps
2. If i select "COLD"from dropdown list it only shows the STEP 1 (hides the rest of the steps)
3. If i select "HOT" from dropdown list it only shows the First 3 STEPS (hides the rest of the steps)

Thanks

XL-2010

Rich

[Ms-Excel-User]

Hi,

First Select from Step 2 to Step 7 and type this (=$AC$2="cold") formula in conditional formatting.

And Select from Step 4 to Step 7 and type this (=$AC$2="hot") formula in conditional formatting.

Finally, font and border and background color have must change to white color in conditional formatting.

[Charles]

Hi,

I used a Worksheet Change event for this.
Any time you change the selection the data in the desired location with change.
If you want to see all of the data you look at the code and then create another code that will display the
Data. Or select "Caustic" and you will see all ot data. you can then change it if you wish.