Hide or Show rows based off value of cell in that row?

Hello,


I have a worksheet named "Requirements" that I would like rows to be hidden dependent on whatever the value of cells L25:L1078 are.

So, if L25 is "True" then Row 25 goes hidden. Likewise, if data changes and L25 changes to "False" I would like row 25 to reappear.

I would like this to be true for rows 25 through 1078.

Is there any way to do this without VBA being used? If not, can anyone provide baby steps for how to accomplish in VBA. I have very little experience with VBA.

Any help would be greatly appreciated.

On my sheet "Requirements", cells in column L either return a value of True or False. These values come from a sheet named "Power Menu" and are based off of whether the a particular cell has a value greater than 0.

The "Power Menu" cells are populated based on data it receives from other sheets. I can enter data in other sheets, check to confirm that the "Power Menu" updated correctly, and then go to the "Required" sheet with no apparent changes to the view. If I manually click to run the macro you created, it then updates. Am I missing something in the setup that would make this a dynamic process where when data changes the macro runs on it's own, updating the correct rows?

Here is a quick watered down sample that should show what I am trying to do with the requirements sheet.

Thanks... I am a bit dense when it comes to VBA and using it correctly. I have added the script from your sample to the same sheet in my workbook. My apologies, but how do I get it to work. Am I missing a step?

Here is the actual sheet that I am working on. You can see that your script works, but then seems to only partially update, then not update at all. Note the "true" rows still being displayed.

Hey sorry to thread jack, but how will this work if i want to hide a cell that is blank?

Instead of "True" what should one enter, THANKS!