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
Blindspots's user avatar
  • 4,525

Only top scored, non community-wiki answers of a minimum length are eligible