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

 

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