Visually hide cell value but keep it for calculations?

How can I visually hide a cell value in display and print but keep it for calculations (=formulas in other cells can refer to it)?

Please note: I don't want to move the cell value to another cell (far away). It should be exactly in this cell for calculation reasons.

Peter

format the text as white text.

And moreover you may format the cell with white font color with conditional formatting so that no one can change the font color of that cell from the format menu. You can use a simple formula for conditional formatting.

Select the cell (say A1) and make a New Rule for conditional formatting using the below formula and set the font color as white.

Please Login or Register  to view this content.

You can also change background color with conditional formatting.

One way to achieve this is, custom format the reference cell as ;;; (Three Semicolons) to hide the cell value but you can still access that cell value in any formula.

Does this help?

You're welcome.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation if the solution provided helped you. This is another way to say thanks.