Fill a cell based on other cells being filled

JessS2170 Let's assume that the first row of scores will be row number 5 and that the assignments and scores are entered in columns B:S. To make your life easier, use the number 1 to mark an assignment complete.

Then, create a conditional formula (CF) formula that sums the ranges B5:S5 and compare it to each of the scores 5 to 11 to set the colour. You need one CF rule for each colour.

Select the entire range T5 and down where you want to apply the rule. Let's say, T5:T30

Then enter the following formula for dark blue:

=SUM(B5:S5)=11and set the format to dark blue. Repeat for the other colours.

I've done something like that in the attached file, with only two rules. I trust you can create similar rules in your own files(s).