cell auto cal

Occasional Contributor

So I am filling in a table for the fires our staff attend, I want to be able to auto sum the travel days, days at fire, and s/d day ( stand down ) but then I also want to calculate the orange  cells with a red border which will indicate the first day of different fires, but will also be counted as a orange cell

I was hoping to use the color system so that I could just ad the blue, then the orange, then yellow and red. Then carry this over into the next sheet for the next roster period.


But I have since found that the colour formula doesn’t work real well.


Could you please teach me how you would do this?