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. 

​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.     Read More

​