How to Hide Rows Based on Cell Values In Excel

Thanks for nice video

What if you wanted to do this for more than one set of rows? For example, hide row 2 based on cell A1 AND hide row 5 based on cell A4 etcetera.

Why this does not work for me

Conditional formatting "hides" the row by only changing the font color, not removing the rows.
VBA coding is the only way to physically hide rows based on a cell value?
Is there another option because I can't use macros. Thanks

Thanks. Very simple way to get the job done.

Hi, I get "Run-time error '424': Object required" when using macro formula. Any suggestion ?