Is there a solution that will change the color of a gallery input based on time? I have seen the use of icons that change colors but its based on a specific button or selection. I was wondering if there is a formula that would change the color based on an input time + entered time. Example: the default fill is blue. Input time is 12:00PM. Cook time is: 6hrs. At 5:45pm turn Yellow. 6PM turn Green. 6:15PM turn RED.
For instance in the gallery below it shows an IN time of 18:00. Cycle time of 7.5hrs. So in 15min prior to end time turn yellow, green on end time, and red 15min after end time.