I have a spreadsheet that has 9 resource concerns listed. Next to each
concern is a cell with a drop down list (data validation list) where the user
can choose high, medium or low. Below each resource concern are rows that
have questions associated to the concern that they need to answer if they
choose high or medium.

I need a macro that will unhide the rows below the each concern if high or
medium is chosen in the drop down list, but keep the rows hidden if the user
chooses low. It needs to update each time the list is pulled down, so that
if they initially choose low, but come back later and chage it to medium, the
rows will then unhide to show the questions.

Very new at macros, so any help is appreciated. If it is easier to use
something other than a data validaiton list for the choices, I am open to
changing it.