1
vote
Accepted
Apply conditional formatting based on dates listed in row
=50 <= SUMPRODUCT($C$2:$C, EOMONTH($A$2:$A,)=EOMONTH($A2,))
Compares Month-Year, not simply month.
Assumes first cell in range to be conditionally formatted is A2
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
google-sheets-dates × 321google-sheets × 313
formulas × 120
google-sheets-arrayformula × 63
google-sheets-query × 50
conditional-formatting × 24
google-sheets-timestamp × 22
date × 16
google-apps-script × 15
vlookup × 13
importrange × 8
formatting × 8
google-sheets-charts × 8
google-sheets-cell-format × 8
regex × 5
text-formatting × 5
data-validation × 4
google-drive × 3
google-workspace × 3
google × 3
google-sheets-custom-function × 3
google-finance × 3
google-sheets-data-validation × 3
google-forms × 2
sorting × 2