I have a task management spreadsheet and would like to apply a formula to
auto HIDE an entire row when the "% Complete" cell value in that row shows
100% (complete).

I know I can use filters for this but was looking for "smarter" automation
via a formula or macro.

I know a little about macros, but very simplified ones.

Thanks