Is there a way to conditionally hide a row? I want to hide rows based on an answer in a cell in its row. I have a client list but want to hide the ones that are not active. So if o2 = ‘yes’ then I want row 2 to be hidden, and if o3 = ‘no’ or blank then I want it shown…
I want to keep the information in the remaining cells (last contact, what type of client, etc) for future follow up and info but it doesn’t need to be seen on a daily basis.