Conditional formatting based on a SUMIF

Make sure to highlight the RANGE or update the APPLIED TO Range to align with what is in the formula you provide to your conditional formatting.

If your list is going to stop at row 500 then use this

Please Login or Register  to view this content.

if it goes beyond 500 you will need to update the 500's in the formula to be an appropriate value aligned with the range you apply it to.

The applied to range that should be set on the formatting should be =$I$3:$AJ$500 as this is the range that is both visible and aligned with the formula

Just to give context - that formula is saying SUM the COLUMN where the WORKER is the WORKER of the given row.

Because the Column is not absolute (Fixed) with the $ symbol, Excel will evaluate each column in the range as its own set.

If the sum of a column is greater than 1 meaning over 100% then it will highlight