Cells change color based on time late

Hi there,

I am trying to have my cell block change color over a series of time based on the time that has been inserted. For example if I enter in the time of 03:21 AM the cell will stay green for 30 minutes, after the 30 minutes it will turn yellow for the next hour and a half until the 2 hour mark is reached at that point it will turn red. Honestly I am not sure if this is possible, but any help would be greatly appreciated.

Hello,

Not sure if this is exactly what you want and but I can see a way of doing it using conditional formatting.
Let say you have 3:21:00 on cell A1
then you add differents times below, on cell A2 then A3 and so forth. Like this:

3:21:00
3:41:00
3:51:00
4:51:00

...for example.

Select the range you want to color (A1:A4) then use conditional formatting to color each cell based on your criteria. In your case it will be:

Green if "range" is less o equal to whatever is on cell A1+0.5/24. (0.5/24 means adding half an hour)
Yellow if "range" is between cell A1+0.5/24 and cell A1+1.5/24
Red if "range" is more than A1+1.5/24

Hope it helps
JG

Attached is the book that I am working on.