How to hide the content of a cell?

[jose luis]

Friends,

I have a range of cells that use conditional formating to hide i
certain condition is met. The way of hiding it is to set the same colo
for font and pattern. It's seems to be protected from the user eye, bu
if you select with the mouse the cells is possible to "see" through th
numbers in the cells that you "Hide" through the "Conditional Formating
. Is there a way to really impede the cells from showing their contents
when you don't want the user to see certain range?

PD. It not possible to hide columns or Rows because the cells ar
insert in a Report that the user has to see. Just some cells need to b
hide from see them.


Any suggestions?


Thanks to all,

Jose Lui

 

[Tom Ogilvy]

format =>Cells=> Protection tab, click on hidden and locked.

Hidden doesn't let the user see the underlying formula or in this case,
value. You will still need the conditional formatting.

Then protect the worksheet. (tools =>protection => protect worksheet)

Note, you need to unlock cells that the user needs to make changes to.

 

[jose luis]

Thaks Tom,

I did what you suggested.

" format =>Cells=> Protection tab, click on hidden and locked"

then Protected the Sheet & Put condition on to Conditional formatting.
Until now OK.

But when I select the range of cells as if i was going to drag, or copy
them. I still can see the values in the cells through the dim screen
that excel puts on the cells to indicate that those cells are selected.
It is possible avoid this to prevent the user see what number is in the
cell?


Thanks for your help.

Regards

jose luis

 

[Gord Dibben]

Jose

Try Format>Cells>Custom ;;;

Won't show through the back color.

Gord Dibben Excel MVP

 

[jose luis]

Thank you Gordon,

that works!!!


The other way i found was to conditional formating the cells an
protecting the sheet just allowing the user to select the unloc
cells.

Thanks again

Jose Lui

 

[Gord Dibben]

Jose

Thanks for the feedback.

Your method also does the job. No select, no see.

Gord