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