I am trying to use a formula in excel to unhide a row if a cell elsewhere in the worksheet has a value of "No." So far I have found only macros to do this, but I am not extremely versed in Macros, can anyone assist?

I will need to use this on multiple lines throughout the workbook.

And if the only way to do this is with a macro, can someone please explain it in the most layman's terms possible?

Thank you,
Eddy