Checkbox to hide rows using cell text as condition

[dexterpoa]

Hi Everyone,

I have a really simple question, but I tried searching all around and couldn't use the other topics to help me solve my problem.

I just need a check box that when checked hides all the rows that have the word "OFF" on column A.

Thanks a lot!

-Dex

[Richard Buttrey]

Hi, and welcome to the forum.

That would require a macro. Are you sure you can't get what you want by filtering the data for values <> A ?

A macro attached to a button or checkbox would do that for you but you may think Autofiltering is more straightforward.
Then other option of course is to use a conditional format and set the font colour to the same colour as the cell background if OFF appear in a column A row,

[dexterpoa]

Thanks for the reply, Richard.

I already have conditional formatting on the rows, but I also need the option to hide them.

[Richard Buttrey]

...you didn't say whether you really needed a macro rather than just a plain old data filter.

If so record a macro to hide the rows and link that to either a simple shape button, or the click event of a check box. When you have your macro then post it here and we'll be able to show you how to generalise it and make it more efficient - the macro recorder can't capture the most efficient way.