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?
