Hi,
Cell E1 date / time extracted from another sub routine in format (m/d/yyyy h:mm AM/PM). require help on date / time background cell color to change.
Not getting desired result with conditional formatting, Kindly suggest.
E1 - Default background color - green
E1 time less than 15 minutes - change background color to yellow
E1 time => than 1 minute - change background color to Red
conditional formats used :
=NOW()-INT(NOW())>E1+TIME(0,1,0)
=NOW()-INT(NOW())>E1-TIME(0,15,0)
Cell E1 date / time extracted from another sub routine in format (m/d/yyyy h:mm AM/PM). require help on date / time background cell color to change.
Not getting desired result with conditional formatting, Kindly suggest.
E1 - Default background color - green
E1 time less than 15 minutes - change background color to yellow
E1 time => than 1 minute - change background color to Red
conditional formats used :
=NOW()-INT(NOW())>E1+TIME(0,1,0)
=NOW()-INT(NOW())>E1-TIME(0,15,0)