I have a spreadsheet where I have a column with a date and time that a client has approved a project. I would like to do a conditional format where the cell turns yellow when the current date/time is 12 hours past the approval date, then red when the date/time is 18 hours past the approval date. Is this something that I can do using the NOW() function? I would like to avoid adding columns if possible.
Bookmarks