I have tried a few formulas for conditional formatting without luck.
I' m trying to have cells change color based on 30min, 60min and 90min passed from a cell containing a specific date & time. Like so:
CELL NEEDS TO BE GREEN IF LESS THAN 30MIN HAVE PASSED FROM INITIAL RESPONSE CELL
CELL NEEDS TO BE YELLOW IF MORE THAN 30MIN BUT LESS THAN 60MIN HAVE PASSED FROM INITIAL RESPONSE CELL
CELL NEEDS TO BE ORANGE IF MORE THAN 60MIN BUT LESS THAN 90MIN HAVE PASSED FROM INITIAL RESPONSE CELL
CELL NEEDS TO BE RED IF MORE THAN 90MIN HAVE PASSED FROM INITIAL RESPONSE CELL
NO FORMATING IF DATE&TIME VALUE HAS BEEN ENTERED IN CELL REGARDLESS OF TIME PASSED
I attached a .xlsx with an example of what I need
any help will be much appreciated
Bookmarks