Excel - Recreating the Dots Game in Excel - Episode 1739

4,741 views · Published 27 June 2013 · 4:52 · Indexed 28 October 2026

Channel: MrExcel.com · 2013 · Education

Watch on YouTube

Microsoft Excel Tutorial: Recreating the Dots Game in Excel | Generate a 6x6 Grid of Colored Dots | MrExcel Podcast.

Welcome to another episode of the MrExcel podcast! In today's episode, we will be discussing a question sent in by Jim about the popular game, Dots. Jim wanted to know if there was a way to generate a 6x6 grid of different colored dots in Excel, similar to the game. So, I downloaded the game and checked it out to see how we could recreate it in Excel.

For those who are not familiar with Dots, the game involves connecting cells of the same color in a 6x6 grid within 60 seconds. Once connected, the dots disappear and new ones appear, similar to Tetris. So, let's dive into how we can create this grid in Excel. We will use the =RANDBETWEEN(1,4) formula to generate a random number between 1-4 in a 6x6 range. Every time we press F9, a new set of numbers will appear.

Next, we will use conditional formatting to assign a different font color to each number. For example, we can choose red for 1, green for 2, and so on. This will give us a visual representation of the different colored dots in the grid. We can also adjust the column width and height to make the cells square, just like in the game.

But, the real challenge is to find the longest string of connected dots, which is what Jim was looking for. To do this, we can use conditional formatting with a formula to highlight cells that are adjacent to the same number. This will help us identify the longest chain of connected dots. However, this may not be as accurate as the game itself, as it is a more complex problem to solve.

So, there you have it, Jim! We have successfully recreated the Dots game in Excel and even added a feature to help identify the longest chain of connected dots. Thank you for sending in your question and for tuning in to this episode of the MrExcel podcast. Don't forget to hit that like button and subscribe for more Excel tips and tricks. See you next time!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:

(00:00) Question from Jim about Dots game on iPad
(00:11) Explanation of Dots game and question about generating grid in Excel
(00:28) Demo of Dots game and explanation of how to play
(01:12) Setting up 6x6 grid in Excel using RANDBETWEEN function and conditional formatting
(02:38) Changing numbers to dots using custom number format
(03:15) Setting up rules to highlight cells with same adjacent colors
(04:28) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Changing number format to display dots
Conditional formatting in Excel
Connecting cells in Dots game
Detecting patterns and connections in the Dots game
Dots game on iPad
Episode 1739 - Dots
Formatting font colors based on cell values
Generating a 6x6 grid in Excel
Learn Excel
Setting column width and height in Excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153561/



Jim sends in today's question. Jim is a fan of an iPad game called Dots. You have a 6x6 grid of dots that appear in four colors. You are trying to find the longest connection of dots of the same color. Jim wondered if Excel could generate a random 6x6 grid of four colors of dots to look for patterns. 

In today's episode, see how to use RANDBETWEEN, conditional formatting and a custom number format to generate the grid of dots. But finding patterns is going to be tougher. While the human brain can detect the patterns, a formula in Excel to find the longest connection would be tougher. The video ends with some conditional formatting to highlight the possible connecting cells but no method for finding the longest connection.

More from this channel