I have a list of appointments wich consist of a appointment date cell, an appointment time cell, a last name cell and a phone number cell.
I want a row to turn green when the time is past on the appoinment date and orange when the appointment date is todays date and the time is within an hour from the current time.
Example:
- Appointment is 11-03-2021 at 12:15. When the appointment is past, like 11-03-2021 at 12:16, the entire row has to turn green and stay that way.
- Appointment is 11-03-2021 at 13:15 and the current date/time is 11-03-2021 at 12:16, the row has to turn orange, because the appointment is within an hour.
If possible, I want to keep the date and time cells seperately.
Bookmarks