Hello all, hoping somebody knows how to make this work, or can state it is not possible.
I have 16 industrial ovens. At the end of the cook cycle, I must chill the product, and must chill it in a certain amount of time. I want to alert the operators to check temperatures at certain intervals. An example of that is below.
At the vary top row, I’d like to display the time. As in =NOW()
The next row, (and 15 more below it, 1 row for each oven) column A would have the oven identifier. Column B would have the time at the end of the cycle, manually input.


Column C, D, and E would indicate the first check, second check, and third check times.
I thought this would be as simple as manually inputting the end time of cook in B, and then simply do a “+5” (meaning add 5 hours) in column C reference column B, and a +5 in column D referencing C, and then something like “+10) in column E, referencing D.
Then do a conditional format in each for C, D, and E, referencing time now from the top. Make the cell turn yellow when it gets to be 30 minutes or less from time needed, and then Red when 5 minutes before the needed time.
But apparently, not so simple.
Help?

THANK YOU!