If No - Hide certain cell text, If Yes display the text

=if(n10="no","","whatever text you want")

You could use what zumbalj said, but I don't think you want to do all that work. You might want to start a thread over in the Excel Programming / VBA / Macros sub-forum for VBA code to stick in to your sheet.

I don't think that would be too much work if you left your text cells in a hidden column and linked to them- one formula to drag down.

If you're going to suggest to someone to manually hide cells, when they asked for a way to do it automatically, why bother suggesting anything at all?

1. Wanted to point out that your tone is condescending. I assume that is not your intention (if I am wrong, please correct me), but for future reference, you might be more careful how you phrase comments that could be construed that way.

2. I assume all the text is known ahead and this is a userform that will display the text based on one yes/no answer in cell N10. With that assumption (again, if that's wrong, Louie please correct me), this would be a quick way for a new Excel user to accomplish the task with one-time changes. VBA can be extrememly challenging for a new user as Louie described him/herself, so I went for the easier to accomplish and easier to troubleshoot solution.