Skip to content

Illustrate Probability with Conditional Formatting

Playback Speed:

In this extension, you will make your probability data easier to understand by using conditional formatting.

Conditional formatting changes the background color of cells in a spreadsheet that contains certain words or numbers.

This helps your viewer see the most important parts of your data without having to read through the entire sheet.

You can apply conditional formatting to your Probability column to make it easy to see which outcomes are most likely and which are least likely.

To start, open your probability spreadsheet.

Select all of the results in the Probability column.

Then, use the toolbar to open the conditional formatting menu.

The data in the Probability column shows the likelihood of rolling each possible outcome.

To visualize this data, create a color scale that assigns each number a particular shade of color.

Change the minpoint -- or lowest value -- dropdown from min value to number.

The lowest number in your column is two point eight percent.

This appears as a decimal.

Next, update the other dropdowns to numbers as well.

Your middle and highest numbers will appear in the menu next to the midpoint and maxpoint.

Choose a color to represent the least likely outcome.

Then, choose another color to represent the most likely outcome.

The midpoint color automatically blends the minpoint color and the maxpoint color.

Now, when you look at your table, it’s easy to see which outcomes are the most likely...

And which are the least likely.

Great work!

Now, it’s your turn: Apply conditional formatting to your probability calculations Select a color scale, Choose colors for the minpoint and maxpoint, And look at your data to see which outcomes are most likely and which are least likely.

Choose an Extension
Illustrate Probability with Conditional Formatting

In this extension lesson, students illustrate probability data using conditional formatting in Google Sheets.

Create an Event Based on the Weather Forecast

Students use Google Search to find the weather forecast and then they create an event in Google Calendar.

Make a Table to Visualize Probability

Students visualize and solve a probability problem using a table in Google Sheets.

Learn the Law of Large Numbers

Students learn the law of large numbers and demonstrate the law using Google Sheets.

Format Titles and Tables with Google Sheets

Students learn how to enhance a spreadsheet by formatting titles and tables in Google Sheets.

Create a Batting Order Using Probability

Students create a batting order by analyzing and sorting probability data in Google Sheets.


Choose an extension from the list to continue learning ways to use Google Sheets to perform calculations.