Create an interactive Higher or Lower guessing game in Microsoft Excel using formulas, functions, data validation, conditional formatting, cell formatting, and multiple worksheets.
Open a new Excel workbook.
Type Higher or Lower in cell A1.
Merge and center cells A1:G1.
Type Guesses in cell A2.
Type Results in cell C2.
Type Hidden Number in cell E2.
Type Number of Guesses in cell G2.
Increase the font size and bold the text in each cell where you entered a heading.
Center-align and middle-align all heading text.
Wrap the text in cells E2 and G2 so the text fits on two lines. Resize the row height if necessary.
Change the fill color for your entire worksheet.
Change the fill color and font color of cell A1.
Change the fill color and font color of cells A2, C2, E2, and G2.
Change the fill color of cells A3:A12, C3:C12, and G3 to white.
Change the fill color and font color of cell E3 to a color of your choice. The fill color and font color must be the same so the hidden number cannot be seen.
Resize columns B, D, and F to a column width of 1.15.
Add a new worksheet and name it Hidden Number. Use Fill Series to create a list of numbers from 1 through 200 in column A.
On the Game worksheet, add data validation to cell E3. Create a dropdown list using the numbers 1 through 200 from the Hidden Number worksheet. Make the text color match the cell color to hide the selected number.
In cell G3 on the Game worksheet, use a function to count the number of guesses entered under the Guesses column.
Add conditional formatting to cell G3 so the font turns red when the player guesses more than seven times.
In cell C3, enter the following formula so the worksheet tells the player whether to guess higher or lower:
=IF(A3="","",IF(A3=$E$3,"You Win",IF(A3<$E$3,"Higher",IF(A3>$E$3,"Lower","Higher"))))
Copy or fill the formula from C3 through C12 as needed.
Add conditional formatting to cells C3:C12. Make the cells display specific colors when the result says Lower, Higher, or You Win.
Center-align, middle-align, bold, and increase the font size of cells A3:A12, C3:C12, and G2.
Format the word Higher in cell A1 using one font style and the word Lower using a different font style.
Rename Sheet1 to Game.
Change the tab colors on both worksheets.
Make any additional design changes you would like.