Solved cell lock by related cell value

December 25, 2018 at 01:20:22
Specs: Windows 10
hi, if my cell A1 is holiday/weekend day then B1 will lock or restrict to enter any data. example- in a table column A is a date & other column is data. now if any cell value in column A is weekend day or holiday then this date cells all row will restrict to entry any data. if i paste any value in this restrict cell then it will automatically skip to the next below cell. pls help me.

See More: cell lock by related cell value

Report •

December 25, 2018 at 04:11:10
✔ Best Answer
Hi Rachel, googling:

'spreadsheet restrict entry by date'

finds a number of hits on such.

Suggest you advise the Spreadsheet you intend using, also the Country involved, as holidays dates differ between Countries, possibly also the weekend dates, as in the case of Fridays for Muslim and Jewish Countries.

Good Luck - Keep us posted.

Report •
Related Solutions

Ask Question