If you find any of this useful, please consider donating via PayPal to help keep this site going.

Email news@statisticool.com to sign up to receive news and updates

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 Statisticool.com.

Thanks for reading.

Please anonymously VOTE on the content you have just read:


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

AFFILIATE LINK DISCLOSURE: Some links included on this page may be affiliate links. If you purchase a product or service with the affiliate link provided I may receive a small commission (at no additional charge to you). Thank you for the support!