Hide range in certain conditions

Is it possible to hide a named range under certain conditions.

If cell A1 >5 and cell B1 is <10 then hide range named “Hide this”.

Well, you can do it with this trick

HideRegion.gif

NB Make sure that in the condition formula use the absolute addresses of the cells - $A$1 and $B$1!

Update Your working spreadsheet should look something like this - testHideRange1.ods

Partially working…Input cell is C16
Range to hide is J3:Q14

Formula is $C$16>125.7

When cell C16 is less than 125.7 everything is visible.
When cell C16 is more than 125.7 cells K3 to Q3 and Q4 to Q14 are invisible (as they should be) but the other cells are visible.

Here is link test1.ods - Google Drive

Why is “double quote - three colons - double quote”? In the description of the trick were written “three semicolons and two double quotes”. So why? (I have added your corrected example at the end of my answer)

I either misread or mistyped the instructions. I also found another way to accomplish the hiding - just format the type the same colour as the background - visually the area appears blank. Thx

Yes, you are right, this method works too. However, if the mode Value Highlighting is on, the values will be visible again. The trick with the code format is free from this shortcoming. (And keep in mind - “Thx” too much, it is enough to note the answer as useful with a special button “V”).