Oct 10 2019 01:13 AM
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?
Oct 10 2019 02:11 AM
Oct 10 2019 06:45 AM
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
Oct 10 2019 07:00 AM
OK no problem, attached the updated version. Is it doing what you expected?
Oct 10 2019 07:12 AM
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
Oct 10 2019 07:29 AM