View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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