Hiding rows with conditional formatting


I have a large sub-section of a form that is rarely needed. I have used conditional formatting to hide these fields, but I then have some sub-tables beneath this. Because the table is large, there is a lot of white space pushing the sub-tables off the screen meaning people often don’t see them. I cannot move the hidden section to below the tables, as when they do appear and need filling in, no one will see those and they need filling in.

Is it possible to use conditional formatting to hide the actual rows instead of just the fields?



You may filter subtable records and save the filter as default view.