📅 Format Month, Quarter and Season Rows With Conditional Formatting

What's new

Conditional formatting rules can now target a time frame. Underline every month row, shade your quarter totals, or highlight season columns without touching the weeks around them.

The New Formatting Rule dialog with Month chosen under Time Frames, is anything as the condition, and a navy top and bottom border with a pale blue fill and bold, while the live preview shows only the Month 1 and Month 2 columns formatted

What you can do

Pick the time frames a rule applies to:
Choose Week, Month, Quarter, Half, Year, Season, Total or a relative time frame such as Month to Date in the new Time Frames picker.
Format whole rows:
With time frames on rows, a Month rule formats every column of each month row, so month subtotals stand out from the weeks.
Format just those columns:
With time frames on columns, the same rule formats only the month columns.
Draw a line above and below:
Two new border options, Top and bottom and Left and right, frame a row or a column in one rule.

Why it helps

Find the month and quarter subtotals in a long weekly plan at a glance.
Recreate the subtotal lines your team is used to from spreadsheets, and they carry into Excel exports.