How to hide some rows based on a specific cell value whilst keeping all unused rows hidden

Hi Everyone,

I have a set of Key Performance Indicators from rows 4-35.

I have a drop-down in cell B3 which determines what data to show for each of these Key Performance Indicators.

When the value in cell B3 is "London" I want rows 17-24 & 32-33 to be hidden.
When the value in cell B3 is "Birmingham" I want rows 32-33 to be hidden.

At the same time, regardless of the value in cell B3, I always wants all the rows below row 35 i.e. row 36 onwards, to be hidden. This is because they do not contain data and it makes my Excel look cleaner If I hide these rows.

Can anyone please help me?

I would appreciate it immensely.

Thanks

Please share a sample file as per the yellow banner above.