hide row automatically

[Ruben Schmitz]

Hi,

I am looking to hide the rows with the word ONWAAR in them. The rows I would like to hide are ONWAAR

for example if the row (21:C) has ONWAAR in it, I want row 21 to hide automatically.

Thanks!

 

[Joe4]

Welcome to the Board!

You should be able to do that pretty easily just by using Filters. Just filter on that column and use a Text filter of "Does Not Equal ONWAAR".

 

[Ruben Schmitz]

of course thank you!!

 

[Joe4]

You are welcome!