Conditional Formatting - Format row based on cell value in specific column

Hi guys,

I want to apply conditional formatting via VBA. I know I could do it in about 2 seconds using standard conditional formatting but the users of the spreadsheet copy and paste and drag to fill, and past experience has shown that this screws up the conditional formatting. I'm also aware that I could stop them doing this, but it's not worth the drama

So, I guess I would like an event to run after a cell in column H (Status) is updated, if value = "Open", format that row to fill yellow.

For what it's worth, I've attached the spreadsheet. New Walkthroughs.xlsm

Any help greatfully received...

Thanks.