Lingo style game

ladbroke

Board Regular
Joined
Jun 2, 2006
Messages
175
Office Version
  1. 365
Platform
  1. Windows
Hey,

I am wanting to create a game using Excel that I can use via Zoom with people (I will be administrating the game from my end, and they will be answering via Zoom video chat).
What I am trying to do is create 5 letter words in which they will spell out a word and if the letters match in specific order, the word turns green (much like the UK gameshow currently on ITV, and used to be in USA about 10 years ago - link to USA wikipedia version complete with graphic to help understand what I am trying to do).

Below is a screenshot of my page (the squares are "Merged & Center").
What I am wanting to do, and I tried with conditional formatting (it kind of worked but had issues where if they said an answer like India, India has 2 I's and would highlight both I's despite only 1 being correct and the other being incorrect for the answer being China (only 1 i)), is get the boxes to highlight Green if the letter is correct AND in the right place, or Orange if its correct but in the WRONG place.
I was thinking of maybe using a macro, where once I have typed in the letters I press a macro ready button and it reveals which are correct. But I am absolutely useless as macros despite attempting a course a couple years ago. I am also thinking this might actually be easier.

If anyone is able to help me get around the issue of not highlighting the same letter twice despite it only being correct once, that would be much much appreciated.
This is for a game show round of a family quiz we have done to keep family who are separated by 100s of miles (even 1000's in one persons case) connected.
Many many thanks for reading and hopefully being able to help.

lingohelp.png
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Dan_W

Well-known Member
Joined
Jul 11, 2018
Messages
978
Office Version
  1. 365
Platform
  1. Windows
Hi. I love the idea - I've often thought about how playing games would help families during lockdown, and so would be keen to help out. I understand the concept of the game, I think (reminds me of Mastermind - need to work out the correct arrangment of colour pegs - correct order), but in the example you gave re: India (guess) and China (solution) what would the expected formatting output be (i.e., where there are two 'i's)?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,846
Messages
5,833,937
Members
430,247
Latest member
w9u5280o

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top