I don't know how to do this please help!!!!

%3CLINGO-SUB%20id%3D%22lingo-sub-2157595%22%20slang%3D%22en-US%22%3EI%20don't%20know%20how%20to%20do%20this%20please%20help!!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2157595%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20spreadsheet%20that%20will%20take%20a%20date%20entered%20into%20one%20column%20and%20after%20a%20period%20of%20time%20in%20the%20next%20column%20change%20that%20cell%20color%20to%20indicate%20passage%20of%20time.%20If%20anyone%20knows%20how%20to%20do%20this%20I%20would%20be%20eternally%20grateful%20to%20learn.%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2157595%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-2157653%22%20slang%3D%22en-US%22%3ERe%3A%20I%20don't%20know%20how%20to%20do%20this%20please%20help!!!!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2157653%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F975360%22%20target%3D%22_blank%22%3E%40lostcoz%3C%2FA%3E%26nbsp%3BYou%20will%20need%20to%20apply%20a%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-conditional-formatting-to-highlight-information-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Econditional%20format%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I am trying to create a spreadsheet that will take a date entered into one column and after a period of time in the next column change that cell color to indicate passage of time. If anyone knows how to do this I would be eternally grateful to learn. Thank you

3 Replies

@lostcoz You will need to apply a conditional format

@adversi I have almost zero skill with Excel, when I follow that link I have tried this in a fashion. What I am trying for is when I have a new claim I type into one column the claim number the next column is the date that claim started, then I want the spreadsheet to automatically change the color of the 3rd column based on passage of time letting me know this claim is 3 days old, five days old, 10 days old and then 15 days old. I hope this makes sense

@lostcoz See attached a sample file on how conditional formatting works. Two most important steps is to (i) use the TODAY() function to get todays date to get total days passed from start claim date (ii) Apply the conditional formats in the same order. You can view them like this:

 

adversi_0-1614086888450.png