Unhide and Hide row(s) based on value in a cell in the row above

Am pretty new to vba.

Row 14 will be hidden by default.
Am trying to automatically trigger the unhiding of row 14 based on the value in cell E13, which can have only Yes or No or can be blank.

So if cell E13 is blank or "Yes" then do nothing .. i.e. don't unhide row 14
But if cell E13 is "No", then unhide row 14.

I want the macro to trigger automatically, based on user entry in cell E13. (without a button to manually trigger).

I have searched other answers and have tried to adapt the closest ones to my problem but no success.

Any help - specially with sample code -will be appreciated.

thanks

Thanks Ken, that worked seamlessly.

appreciate your quick reply.

Thanks, Marvin.
This works too.
Actually, my worksheet has several such conditional un-hiding of rows required, and I thought if I get the code /pointers for one instance I could repeat it for other instances.
Keep in mind though that the trigger for unhiding is not the same.
For, example a YES in E11 triggers un-hiding of row 12
while a NO in E13 triggers un-hiding of row 14 (as per my original post for which your solution as well as Ken's solution works.

As I guess, I can have only one Worksheet_change macro, I need to define all these cells (E11 and E13 as targets and give the different cases for the triggers.

Any help with this will be appreciated.

Regards,

Jammi

Thanks Alan.
I had a follow up question so will mark this thread SOLVED once I get the solution to that.
Regards,
Jammi

Hey Marvin,

Figured out that I had to only repeat the IF-EndIF sequence for each of the cells where I have the triggers.

Thanks for all the help guys.

Regards,

Jammi