I am looking to use this auto hide function as explained on this article but with no luck https://support.jetglobal.com/hc/en-us/articles/218953738-Conditionally-Hiding-Rows-Columns-or-Sheets
Can someone explain to me how this function works? Just by typing Auto+Hide in cell A1, Hide+? in B1 and an 'IF' formula against the rows then the sheet will automatically 'Hide' rows? If that is the case then what am I doing wrong here, see attached image. My 'hide' rows are not hiding.