Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Kind of...
You can't hide stuff by using formulas in cells in a worksheet, but you may be able to use format|Conditional formatting to hide the value (use a white fill on a white font???). Say the value in B1 should be hidden if the value in A1 equals x. Select B1 Format|conditional formatting (xl2003 menus) formula is: =A1="x" and format it nicely (white on white) Bas8178 wrote: Is it possible to hide data using a formula? i.e if i enter a specific number in one cell i can use a formula that hides it in another (but the data is still in that cell) -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hiding Data | Excel Discussion (Misc queries) | |||
Hiding Data while printing | Excel Discussion (Misc queries) | |||
Hiding formula | Excel Worksheet Functions | |||
hiding charts w/o data | Excel Worksheet Functions | |||
Hiding formula but allow changes | Excel Discussion (Misc queries) |