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