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?

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies