Hiding data using a formula
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
|