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/