Multiple automatic conditional unhide rows

[CST]

Hi,

Attached to this post is an example file illustrating what I want to do, which is essentially this:

Rows 5 & 7 will be hidden upon file opening.
When YES is selected from a YES/NO dropdown list in C4, I would like row 5 to unhide.
Similarly, when YES is selected from a YES/NO dropdown list in C6, I would like row 7 to unhide.

Can this be done independently?

Currently, my file has some background VBA that I found from searching these forums that will automatically do the row 5 unhide but I haven't been able to extend it to multiple, independent conditional hide/unhides. I have a feeling I'm missing something embarrassingly obvious but it's been a long time since I last tinkered with macros and VBA.

Thanks!

[protonLeah]

Please Login or Register  to view this content.

[CST]

Thank you! Exactly what I was looking for. +reputation & marked solved.