Excel 2000 Conditional Data Entry
 

I have a large costing spreadsheet, and I want to be able to prevent people
from typing in cells that aren't appropriate. This has to depend on whether
a particular word in entered into another column.

So if column A had 'Forecast' entered into it, the user shouldn't be able to
enter anything into Columns G and H.

But if any other value is entered into the cell, they should be able to
enter data into G and H, but not F.

Is this possible with my version?

Excel 2000 Conditional Data Entry
 

You can look at Data = Validation and see if you can't emplace these
conditions.

--
Regards,
Tom Ogilvy


"HLS" wrote:

I have a large costing spreadsheet, and I want to be able to prevent people
from typing in cells that aren't appropriate. This has to depend on whether
a particular word in entered into another column.

So if column A had 'Forecast' entered into it, the user shouldn't be able to
enter anything into Columns G and H.

But if any other value is entered into the cell, they should be able to
enter data into G and H, but not F.

Is this possible with my version?