SOLVED
Home

Excel Help for time limit.

%3CLINGO-SUB%20id%3D%22lingo-sub-500572%22%20slang%3D%22en-US%22%3EExcel%20Help%20for%20time%20limit.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-500572%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20experts%2C%20please%20help%20me%2C%3C%2FP%3E%3CP%3EIs%26nbsp%3B%20there%20any%20way%20so%20that%20I%20can%20limit%20a%20cell%20for%20a%20specific%20period%20of%20time%20in%20which%20cell%20can%20be%20edited.%20After%20the%20time%20limit%20is%20over%2C%20the%20cell%20should%20not%20be%20edited.%3C%2FP%3E%3CP%3EPlease%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-500572%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-507625%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20for%20time%20limit.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-507625%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329919%22%20target%3D%22_blank%22%3E%40Ahmad200%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20add%20Data%20Validation%20with%20a%20formula%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20591px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111344i30E8C12AFFC885E6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhere%20the%20figure%20of%2043585%20is%20the%20number%20equivalent%20of%20any%20date%3C%2FP%3E%0A%3CP%3E(type%20a%20date%20in%20a%20cell%20and%20change%20the%20format%20to%20General)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-508923%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20for%20time%20limit.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-508923%22%20slang%3D%22en-US%22%3EI%20have%20not%20got%20it.%20Please%20help%20me.%20I%20am%20not%20able%20to%20understand%20what%20you%20said%20in%20your%20response.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-509678%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20for%20time%20limit.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-509678%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F329919%22%20target%3D%22_blank%22%3E%40Ahmad200%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20the%20cells%20you%20want%20to%20protect%20and%20the%20click%20on%20Data%20-%26gt%3B%26nbsp%3B%20Data%20Validation%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20656px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111394i6314C9DF2E9C6E9B%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThen%20choose%20the%20option%20as%20shown%20in%20the%20image%20below%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20591px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111398i30A938F9F19576A1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EOr%20this%20(where%20A1%20is%20a%20reference%20to%20a%20cell%20containing%20a%20date)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20584px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F111408iC2FE26DF218561C1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-510762%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20for%20time%20limit.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-510762%22%20slang%3D%22en-US%22%3EJust%20let%20me%20try.%20I%20will%20respond%20you%20shortly.%20Thanks%3C%2FLINGO-BODY%3E
Ahmad200
Occasional Contributor

Hello experts, please help me,

Is  there any way so that I can limit a cell for a specific period of time in which cell can be edited. After the time limit is over, the cell should not be edited.

Please help me.

4 Replies

@Ahmad200 

 

You could add Data Validation with a formula

 

image.png

 

Where the figure of 43585 is the number equivalent of any date

(type a date in a cell and change the format to General)

I have not got it. Please help me. I am not able to understand what you said in your response.
Solution

@Ahmad200 

 

Select the cells you want to protect and the click on Data ->  Data Validation

 

image.png

 

Then choose the option as shown in the image below

 

image.png

 

Or this (where A1 is a reference to a cell containing a date)

 

image.png

 

Hope that helps

 

Highlighted
Just let me try. I will respond you shortly. Thanks
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies