Can you hide the value contained in a single cell

[Bill]

Thank you in anticaption of replying

 

[Mark]

Thank you in anticaption of replying

You can set the font color to the same as the background color.

 

[Gord Dibben]

Bill

Custom Format of ;;; will leave the cell looking blank.

However you can still see the formula/value in the Formula Bar so you have to
also hide that.

This can be done by locking that cell and check it "hidden" also.

Then you protect the worksheet.


Gord Dibben MS Excel MVP