I'm new to macros, and can't figure this out:

If any of the cells in B2:B8 = "Sem" then all of columns H and I need to be show, but hidden for "Year"


Screenshot:
Excel.gif