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!!!
Last edited by AliGW; 04-10-2020 at 01:42 AM.
Hi Tim, try these conditional formulas:-
Red:- =AND((K2-MOD(NOW(),1))*1440<2,K2<>"")
Yellow:- =AND((K2-MOD(NOW(),1))*1440<5,K2<>"")
Green:- =(K2-MOD(NOW(),1))*1440>=5
They must appear in that order in the conditional list.
Thanks Beamernsw!!! It works!!! New question for the same formula. Why would it work in a regular excel document but not when I upload it to google sheets? We are trying to have multiple devices use the same excel spreadsheet and while in Google Sheets the cells don't change color...
ahh, I've never used Google Sheets I'm sorry to say. I'll have to defer that to one of the sites Guru's
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks