I thought about doing the conditional formatting to make it turn red, yellow, and green, but conditional formatting is always such a pain that it would take another half hour to get right.
I spent seven years scheduling aircraft maintenance. The airlines have specialized software that optimizes it, but the Air Force would rather spend 10x as much making people do it the manual way. We were minimally manned, and I spreadsheeted everything. My boss complained that I wanted to walk in, turn on my computer, and have it do all my work for me. I replied, "Isn't that what the computers are for?"