Hi my name is Tim,
Thanks for the help in advance. So I have a row K where I put a future time. I would like for that cell to start off green and then go yellow when the current time is within 5 minutes of what was entered. Then go red when it is within 2 minutes or past that time. We use this document on google sheets so seeing the cell change color will let everyone who is using it know what to prioritize. I attached the sheet. Please help. Thanks!!!
Bookmarks