Change Cell Color with time

[ryeire]

Hi all,

I am looking to create a code that causes a cell to change color with time. Ideally, I would like to have a button which changes a cell to green and starts a timer simultaneously. Then as the timer runs, the cell would gradually change from green to amber to red after x hours.
I have already created the buttons which change the color of the cell from red to green, I just need code that will change its color with time. If this is even possible.
Thanks in advance.

 

[ryeire]

This is a snip of what I have. The green cell is the cell I am looking to change the color of. The 'done' button changes the cell to green, while the 'to be done' button changes the cell color to red