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

Copper 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