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

--
Message posted from http://www.ExcelForum.com

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.

--
Regards,
Tom Ogilvy

"jose luis " wrote in message
...
Friends,

I have a range of cells that use conditional formating to hide if
certain condition is met. The way of hiding it is to set the same color
for font and pattern. It's seems to be protected from the user eye, but
if you select with the mouse the cells is possible to "see" through the
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 are
insert in a Report that the user has to see. Just some cells need to be
hide from see them.


Any suggestions?


Thanks to all,

Jose Luis


---
Message posted from http://www.ExcelForum.com/

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


---
Message posted from http://www.ExcelForum.com/

Jose

Try FormatCellsCustom ;;;

Won't show through the back color.

Gord Dibben Excel MVP

On Wed, 15 Sep 2004 12:48:00 -0500, jose luis
wrote:

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


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

Jose

Thanks for the feedback.

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

Gord

On Wed, 15 Sep 2004 19:27:53 -0500, jose luis
wrote:

Thank you Gordon,

that works!!!


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

Thanks again

Jose Luis


---
Message posted from http://www.ExcelForum.com/