SOLVED

Hide Formulated Rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2399880%22%20slang%3D%22en-US%22%3EHide%20Formulated%20Rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2399880%22%20slang%3D%22en-US%22%3EI%20have%20a%20tab%20which%20is%20formulated%20to%20produce%20a%20short%20sentence%20from%20data%20input%20on%20previous%20tabs.%20If%20select%20Yes%20then%20sentence%20is%20formed%20on%20comments%20page%20%26amp%3B%20if%20left%20blank%20then%20formula%20for%20the%20sentence%20returns%20a%20%E2%80%9CFALSE%E2%80%9D%20reading.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20like%20to%20hide%20the%20rows%20that%20remain%20%E2%80%9CFALSE%E2%80%9D%20on%20my%20comments%20page%20through%20a%20button.%3CBR%20%2F%3E%3CBR%20%2F%3EAre%20you%20please%20able%20to%20help%20me%20with%20this%20problem%3F%3CBR%20%2F%3E%3CBR%20%2F%3EMuch%20appreciated.%3CBR%20%2F%3E%3CBR%20%2F%3EBill%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2399880%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2400016%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20Formulated%20Rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2400016%22%20slang%3D%22en-US%22%3E1.%20Select%20the%20range%20of%20cells%20that%20may%20contain%20%22FALSE%22%3CBR%20%2F%3E2.%20Click%20Home%20%26gt%3B%20Conditional%20Formatting%20%26gt%3B%20New%20Rule...%3CBR%20%2F%3E3.%20Click%20'Format%20only%20cells%20that%20contain'%20in%20the%20popup%20window.%3CBR%20%2F%3E4.%20Change%20it%20so%20it%20says%20'Cell%20Value'%20'equal%20to'%20'FALSE'%3CBR%20%2F%3E5.%20Click%20Format%2C%20in%20the%20font%20tab%20change%20the%20text%20colour%20to%20white%20and%20on%20the%20Fill%20tab%20change%20the%20background%20colour%20to%20'No%20Colour'%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20won't%20hide%20the%20rows%20but%20will%20hide%20the%20text%20if%20they%20are%20on%20a%20white%20background%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2400024%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20Formulated%20Rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2400024%22%20slang%3D%22en-US%22%3EThanks%20very%20much%20for%20the%20response.%20I%E2%80%99m%20really%20hoping%20to%20hide%20the%20entire%20row%20if%20possible.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2400103%22%20slang%3D%22en-US%22%3ERe%3A%20Hide%20Formulated%20Rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2400103%22%20slang%3D%22en-US%22%3ECan%20you%20send%20a%20screenshot%20example%20of%20the%20rows%20%3F%3C%2FLINGO-BODY%3E
New Contributor
I have a tab which is formulated to produce a short sentence from data input on previous tabs. If select Yes then sentence is formed on comments page & if left blank then formula for the sentence returns a “FALSE” reading.

I would like to hide the rows that remain “FALSE” on my comments page through a button.

Are you please able to help me with this problem?

Much appreciated.

Bill
7 Replies
1. Select the range of cells that may contain "FALSE"
2. Click Home > Conditional Formatting > New Rule...
3. Click 'Format only cells that contain' in the popup window.
4. Change it so it says 'Cell Value' 'equal to' 'FALSE'
5. Click Format, in the font tab change the text colour to white and on the Fill tab change the background colour to 'No Colour'

This won't hide the rows but will hide the text if they are on a white background
Thanks very much for the response. I’m really hoping to hide the entire row if possible.
Can you send a screenshot example of the rows ?
The “FALSE” rows are the ones I want to hide. They are formulated from prior tabs with IF formulas & if satisfied show a short sentence like the one in the attachment about rental income. If they remain false I’d love to hide them. Thanks again so much for your time & responses

@Billyb99 

Did you try to apply filter to column C (select it, Data->Filter) and uncheck FALSE in filter drop down?

best response confirmed by Billyb99 (New Contributor)
Solution

@Billyb99 

 

Sergei is correct. The easiest way to do this without VBA code is to apply a filter to the column.

 

1. Add a column header then select the column range and then click Data > Filter

StoneKiwi_3-1622492155363.png

 

2. Click the dropdown arrows and uncheck 'FALSE'

StoneKiwi_4-1622492191476.png

 

3. The rows with 'FALSE' will now be hidden

StoneKiwi_2-1622492092428.png

NOTE: The filtered rows will not automatically updated if values change. You will have to refilter it each time by unchecking and then rechecking 'FALSE' in the filter

Thanks again. I’ll give this a go. Think I might’ve been trying to overcomplicate it! Appreciate your time.