How to protect & hide Sheet

[Panchi]

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

 

[clr]

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

 

[Bill Kuunders]

see below

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

 

[Panchi]

Thanks all for the response.

see below


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.


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.


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

Greettings from New Zealand