SOLVED

Data validation

Copper Contributor

safoine_0-1619398054919.png

Hello please I want to make condition on cases. if today date superior then the fixed date then i can't modify them but the formula won't work please the solution 

2 Replies
best response confirmed by safoine (Copper Contributor)
Solution

@safoine 

Use

 

=TODAY()<DATE(2022,1,1)

 

Warning: users will still be able to copy/paste into the cells!

i locked the sheet with password too
1 best response

Accepted Solutions
best response confirmed by safoine (Copper Contributor)
Solution

@safoine 

Use

 

=TODAY()<DATE(2022,1,1)

 

Warning: users will still be able to copy/paste into the cells!

View solution in original post