Fraction Shaded


With the recent Coronavirus Disease 2019 (COVID-19), many children are at home because schools are closed. Education and fun, however, should not stop. Here is a spreadsheet I created so kids can practice their fractions by shading in shapes.

This spreadsheet uses conditional formatting to shade in randomly selected cells in a rectangle. The student just counts the number of cells that are shaded in and writes down the fraction.

The spreadsheet creates just five problems, and each problem is a rectangle comprised of nine cells. Please feel free to edit the spreadsheet with smaller/larger rectangles or any other shapes.

The user can enter a probability of each cell in a large rectangle (or other shape) being shaded in. As mentioned, Excel's "Conditional Formatting" is used to do the shading.

I set the Print Area, that is, the area that will be printed out when you click Print, to be the area with the words in the outlined box. This way, you can just open up the spreadsheet and print. You can also press F9 to create new random numbers and shaded shapes.

Click here to download the spreadsheet.

Please edit this spreadsheet as needed. If you find this spreadsheet useful, please credit

Thanks for reading.

If you enjoyed any of my content, please consider supporting it in a variety of ways: