I know there is probably a simple way to do this, but I'm new to VBA. I have multiple drop-down lists and for some I am trying to unhide rows if a specific drop-down item is selected and rehide them if the drop-down item is later changed. For example, if in row 17 "Red" is selected, rows 18 and...