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
Highlighted
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
Highlighted

@cwor33 

 

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

Highlighted

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 

Highlighted

@cwor33 

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

Highlighted

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 

Highlighted
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