View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bony Pony[_2_] Bony Pony[_2_] is offline
external usenet poster
 
Posts: 71
Default Hiding data using a formula

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

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