Forum Discussion
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.
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).
- What about COUNTIFS() function?
