Skip to Content
0
Jul 16, 2008 at 02:26 PM

Particular cells are only active in a column

17 Views

Hi,

I have a requirement.

My Lead columns is - Fiscal Period / Year (This contains from Jan to Dec, 2008)

My Data columns are:

Actual (Non-Modifiable)

Budget (Non-Modifiable)

Previous Forecast (Non-Modifiable)

Current Forecast (First fourth months are modifiable and remaining 8 months are non-modifiable)

In the current forecast first 4 months are copied from the actual data. Therefore, I want to disable these four cells. Remaining next 8 months are copying from Budget to Current Forecast and the user is intended to change those copied figures.

Is there any way that I can restrict only particular cells to be deactivated and remaining cells to be active in a layout.

Any valuable inputs will be highly appreciated.

Regards,

Ravi