SOLVED

Data validation

%3CLINGO-SUB%20id%3D%22lingo-sub-2289359%22%20slang%3D%22en-US%22%3EData%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2289359%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22safoine_0-1619398054919.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275432i6FE3B9EEAFCAEB48%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22safoine_0-1619398054919.png%22%20alt%3D%22safoine_0-1619398054919.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHello%20please%20I%20want%20to%20make%20condition%20on%20cases.%20if%20today%20date%20superior%20then%20the%20fixed%20date%20then%20i%20can't%20modify%20them%20but%20the%20formula%20won't%20work%20please%20the%20solution%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2289359%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2290885%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2290885%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F866856%22%20target%3D%22_blank%22%3E%40safoine%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DTODAY()%3CDATE%3E%0A%3C%2FDATE%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWarning%3A%20users%20will%20still%20be%20able%20to%20copy%2Fpaste%20into%20the%20cells!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional 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 (Occasional 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