Home

conditional formatting - highlight dates 48hrs greater or less than another date

%3CLINGO-SUB%20id%3D%22lingo-sub-904795%22%20slang%3D%22en-US%22%3Econditional%20formatting%20-%20highlight%20dates%2048hrs%20greater%20or%20less%20than%20another%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904795%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20using%20excel%20formula's%2C%20i%20have%20a%20spreadsheet%20which%20has%20an%20admission%20date%20and%20a%20date%20collected%2C%20I%20need%20to%20highlight%20in%20column%20A%20if%20the%20date%20is%202%20days%20greater%20than%20column%20D%20date%20and%20if%20less%20than%20I%20need%20to%20highlight%20green%3F%20can%20somebody%20explain%20how%20i%20do%20this%20please%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-904795%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-904888%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20-%20highlight%20dates%2048hrs%20greater%20or%20less%20than%20another%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-904888%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423493%22%20target%3D%22_blank%22%3E%40cwor33%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20please%20see%20attached%20file%20and%20let%20me%20know%20if%20this%20is%20what%20you%20need%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-905389%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20-%20highlight%20dates%2048hrs%20greater%20or%20less%20than%20another%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905389%22%20slang%3D%22en-US%22%3E%3CP%3Ethank%20you%20for%20your%20response%20i%20want%20the%20days%20column%20to%20be%20hidden%20and%20if%20the%20admission%20date%20is%202%20or%20more%20days%20than%20the%20collection%20date%20i%20ned%20th%20admission%20date%20to%20turn%20red%2C%20if%20it%20is%20less%20than%202%20days%20i%20need%20the%20admission%20date%20to%20turn%20green%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-905460%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20-%20highlight%20dates%2048hrs%20greater%20or%20less%20than%20another%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905460%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423493%22%20target%3D%22_blank%22%3E%40cwor33%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOK%20no%20problem%2C%20attached%20the%20updated%20version.%20Is%20it%20doing%20what%20you%20expected%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-905481%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20-%20highlight%20dates%2048hrs%20greater%20or%20less%20than%20another%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905481%22%20slang%3D%22en-US%22%3E%3CP%3EThat's%20it!%20how%20do%20i%20use%20it%3F%20what%20is%20the%20formula%3F%20could%20you%20tell%20me%20step%20by%20step%20so%20i%20know%20for%20next%20time.%20thank%20you%20so%20much%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422482%22%20target%3D%22_blank%22%3E%40PascalKTeam%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-905517%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%20-%20highlight%20dates%2048hrs%20greater%20or%20less%20than%20another%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-905517%22%20slang%3D%22en-US%22%3EWell%20it's%20done%20with%20conditional%20formatting.%20Click%20any%20of%20the%20cells%20and%20then%20go%20to%20Home%20-%20Conditional%20formatting%20-%20manage%20rules%20to%20see%20how%20it%20was%20done.%20Maybe%20best%20to%20watch%20a%20youtube%20video%20on%20that%20topic%20in%20case%20you%20have%20no%20experience%20with%20conditional%20formatting%3C%2FLINGO-BODY%3E
cwor33
New Contributor

Hi, 

 

I am new to using excel formula's, i have a spreadsheet which has an admission date and a date collected, I need to highlight in column A if the date is 2 days greater than column D date and if less than I need to highlight green? can somebody explain how i do this please?

5 Replies

@cwor33 

 

Hi, please see attached file and let me know if this is what you need

thank you for your response i want the days column to be hidden and if the admission date is 2 or more days than the collection date i ned th admission date to turn red, if it is less than 2 days i need the admission date to turn green @PascalKTeam 

@cwor33 

OK no problem, attached the updated version. Is it doing what you expected?

That's it! how do i use it? what is the formula? could you tell me step by step so i know for next time. thank you so much @PascalKTeam 

Well it's done with conditional formatting. Click any of the cells and then go to Home - Conditional formatting - manage rules to see how it was done. Maybe best to watch a youtube video on that topic in case you have no experience with conditional formatting
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
16 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
11 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies