How to protect & hide Sheet
 

Hi..

I have a few questions :

1. I have a sheet which has data in rows. How can I have the row highlighted
in red if a particular cell A3 is blank for example whereas cell A1 has the
required data in it?

2. Is it possible to protect only 1 sheet of a workbook? I have mutliple
sheets in a workbook which has to be updated and mailed but I don't wan't
the recepient to see any data on a particular sheet only. I can hide the
sheet but anyone can open that sheet be unhiding that sheet.

3. I have a shared worksheet where alot of people update the sheet as
required. How can I have a cell formatted so that only 8 digits can be
entered?

Thanks,
Panchi

How to protect & hide Sheet
 

Hi Panchi.......

1- The feature that will help you do what you want here is called
Conditional Formatting. To access it, select the cell of interest and do
Format Conditional Formatting and follow the Menus.

2- Yes, it is possible to protect a single sheet in a multi-sheet workbook,
but that alone does not prevent a user from viewing it. Excel is not
designed to be a secure environment. You simply cannot secure any
information therein that an Excel Gure cannot access. If you have
confidential information you do not wish to share, you must take other steps
to preserve it's security......for one, DON'T send it to anybody!

3- To limit a cell entry to 8 digits, use Data Validation Allow: Text
length Data: less than or equal to Maximum: 8 OK

Hth
Vaya con Dios,
Chuck, CABGx3


"Panchi" wrote in message
...
Hi..

I have a few questions :

1. I have a sheet which has data in rows. How can I have the row
highlighted
in red if a particular cell A3 is blank for example whereas cell A1 has
the
required data in it?

2. Is it possible to protect only 1 sheet of a workbook? I have mutliple
sheets in a workbook which has to be updated and mailed but I don't wan't
the recepient to see any data on a particular sheet only. I can hide the
sheet but anyone can open that sheet be unhiding that sheet.

3. I have a shared worksheet where alot of people update the sheet as
required. How can I have a cell formatted so that only 8 digits can be
entered?

Thanks,
Panchi

How to protect & hide Sheet
 

see below
"Panchi" wrote in message
...
Hi..

I have a few questions :

1. I have a sheet which has data in rows. How can I have the row
highlighted
in red if a particular cell A3 is blank for example whereas cell A1 has
the
required data in it?

select the whole row
go to ,,format,, conditional formatting,,
select "formula is" in the dropdown box that says "value is"
enter =$A$3=""
click the format button and select in the pattern tab the red colour.


2. Is it possible to protect only 1 sheet of a workbook? I have mutliple
sheets in a workbook which has to be updated and mailed but I don't wan't
the recepient to see any data on a particular sheet only. I can hide the
sheet but anyone can open that sheet be unhiding that sheet.
yes
for others not to see anything?
make sure that they can not select any cells ---de-select the top ticks in
the list while protecting the sheet.
format all cell text to be white.


3. I have a shared worksheet where alot of people update the sheet as
required. How can I have a cell formatted so that only 8 digits can be
entered?

select data
data validation
allow the text length to be equal to 8

Greettings from New Zealand

How to protect & hide Sheet
 

Thanks all for the response.


"Bill Kuunders" wrote in message
...
see below
"Panchi" wrote in message
...
Hi..

I have a few questions :

1. I have a sheet which has data in rows. How can I have the row
highlighted
in red if a particular cell A3 is blank for example whereas cell A1 has
the
required data in it?

select the whole row
go to ,,format,, conditional formatting,,
select "formula is" in the dropdown box that says "value is"
enter =$A$3=""
click the format button and select in the pattern tab the red colour.


2. Is it possible to protect only 1 sheet of a workbook? I have mutliple
sheets in a workbook which has to be updated and mailed but I don't wan't
the recepient to see any data on a particular sheet only. I can hide the
sheet but anyone can open that sheet be unhiding that sheet.
yes
for others not to see anything?
make sure that they can not select any cells ---de-select the top ticks in
the list while protecting the sheet.
format all cell text to be white.


3. I have a shared worksheet where alot of people update the sheet as
required. How can I have a cell formatted so that only 8 digits can be
entered?

select data
data validation
allow the text length to be equal to 8

Greettings from New Zealand