Hiding data using a formula

[Bas8178]

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]

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)

 

[Bony Pony]

Hi,
Format the cell using a custom format of ;;;

This hides the content without the need for colouring the font.

Hope this helps

Regards,
Bony