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?

4. In addition to above, how can I limit the length of characters allowed in
a cell not to exceed 40 characters.

Thanks,

 

[trip_to_tokyo]

For number 4. in EXCEL 2007 try the following:-

- click in the cell that you wish to restrict (I 9 for example)

- Data

- Data Tools group

- Data Validation

- Data Validation

The Data Validation window should now launch.

- Settings tab

- Allow: Text length

- Data: between

- Minimum: 0

- Maximum: 40

OK

You should now find that you cannot enter more than 40 text characters in
the selected cell(s).

If my comments have helped please hit Yes.

Thanks.

 

[Panchi]

Sorry forgot to mention that I am using Excel 2003.

 

[trip_to_tokyo]

It's a bit late now! (only joking - no prob).

Sorry forgot to mention that I am using Excel 2003.




.