Auto Hide/Unhide rows in Excel based on formula result in a column

Hi,

I am new to VBA/Macros and am looking for some help please.

I have a spreadsheet where I would like the rows to hide/unhide automatically based on a value in a column (either 0 or 1). The value is driven by a formula. I want rows with 1 value to display (unhide) and rows with 0 value to hide. I also want to be able to apply the macro to a range of rows but for it to ignore (ie keep displayed) rows where the column value is blank.

Attached is a simple example. Can anyone help me with the code please?

Thanks
Kim