# Fill a cell based on other cells being filled

Copper Contributor

# Fill a cell based on other cells being filled

Hello,

I am working to create a daily score for my students as they complete their work. What I would like to do is as I put an "x" in the cell they have completed, after so many are filled, then a separate box will change colors per the amount of x's in the other cells. I know about conditional formatting but I am struggling with getting the formula correct. Any help would be appreciated.

2 Replies

# Re: 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).