Conditional Cell protection
I would like to blank and protect certain cells depending on a value in one
cell (A1). If, e.g. the value in cell A1 is 6, then the users are only allowed to enter values in the first 6 weeks for that year (=first 6 columns in the table). In order to avoid problems I would like to erase all existing data in columns 7-- and then lock these cells. Any ideas how to do this? |
All times are GMT +1. The time now is 11:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com