About Us

trip_to_tokyo[_3_]

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

"Panchi" wrote:

Sorry forgot to mention that I am using Excel 2003.

"trip_to_tokyo" wrote in message
...
Hi Panchi, for number 3, please see my other posting (with regard to
number
4) and just play with the settings until it gives you what you want.

If my comments have helped please hit yes.

Thanks.

"Panchi" wrote:

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,

.

.

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Protect sheet but hide rows?	FTM	Excel Discussion (Misc queries)	7	March 29th 08 04:24 PM
Hide/Unhide after protect sheet	RKS	Excel Discussion (Misc queries)	0	March 21st 08 05:03 AM
HIDE AND PROTECT A CELL	NEIL	Excel Worksheet Functions	0	March 8th 07 08:55 PM
Protect hide worksheet	Lawrence	Excel Worksheet Functions	4	December 20th 05 12:48 PM
Excel 2002 "Protect Sheet", but allow "Hide Columns"?	VP Safe	Excel Worksheet Functions	2	July 5th 05 07:13 PM

Menu

About Us