Hi, I’ve created a holiday calendar for team members, using a red background fill to indicate people being away. Now I’d like to add a summary row, showing the available time with a green background fill, when nobody is on holiday – so as to easily see available times for scheduling meetings.

A possible rule might look like this: Cell C26 = green fill if cells C1 to C25 contain no fill. Cell C26 = no fill if cells C1 to C25 contain (one or more) cells with background fill. This rule would then be applied to all cells of row 26. Any suggestions? 

​Hi, I’ve created a holiday calendar for team members, using a red background fill to indicate people being away. Now I’d like to add a summary row, showing the available time with a green background fill, when nobody is on holiday – so as to easily see available times for scheduling meetings.A possible rule might look like this: Cell C26 = green fill if cells C1 to C25 contain no fill. Cell C26 = no fill if cells C1 to C25 contain (one or more) cells with background fill. This rule would then be applied to all cells of row 26. Any suggestions?   Read More

​