Ask Your Question

Hide range in certain conditions

asked 2017-09-08 16:24:05 +0200

dogluvver gravatar image

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".

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2017-09-08 21:00:47 +0200

JohnSUN gravatar image

updated 2017-09-09 07:46:59 +0200

Well, you can do it with this trick


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 - C:\fakepath\testHideRange1.ods

edit flag offensive delete link more

answered 2017-09-08 22:44:41 +0200

dogluvver gravatar image

updated 2017-09-08 23:41:49 +0200

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

edit flag offensive delete link more


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)

JohnSUN gravatar imageJohnSUN ( 2017-09-09 07:52:55 +0200 )edit

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

dogluvver gravatar imagedogluvver ( 2017-09-10 00:42:19 +0200 )edit

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").

JohnSUN gravatar imageJohnSUN ( 2017-09-10 08:43:02 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-08 16:24:05 +0200

Seen: 85 times

Last updated: Sep 09 '17