Excel Logical Functions applied to MasterMind

MasterMind Game and a Process of Elimination

I have a basic Process of Elimination procedure on paper that solves the MasterMind challenge , using 6 colors and the standard 8 rows of testing,

I would like to use Excel logical functions to create a basic MasterMind solver game.
I'm hoping to find someone who would enjoy the challenge of working on this problem and begin a dialogue seeking a solution.

For someone interested but not knowing how the game is played, there are a number of internet sites devoted to the MasterMind game on the internet.
The game has 2 players. The first player (the codemaker) creates a code by choosing four random colors out of a possible 6 and placing them in a particular position with 4 possible slots (holes). This code is hidden from view.
The other player makes a guess by placing colored pegs in the first row. Then the codemaker responds by using black pegs for correct color and correct position or a white peg if the color is right but in the wrong position and no peg if neither color or position is correct.

The problem is to transfer the paper structure into a series of Excel logical functions. I understand that a program could incorporate the whole game more efficiently, but it would be intellectually satisfying to discover how the problem can be solved with logical functions.

I use letter references for each color: B for blue, G for Green, P for Purple, Y for Yellow, O for Orange and R for Red.

What is needed:
The Codemakers original placement
1. Set a code, say to place B in position 1, R in position 2, Yellow in position 3 and Purple in position 4?
A follow up to this would be for Excel to randomly generate a code.

2. Next would be the players selection of a color for each of the 4 available slots (holes for pegs).
The idea of having an Excel cell with one of the unique colors available for the player to choose/select. Would need a means to cancel a selection and choosing another color.

3. How can logical functions evaluate the color and position of a guess as it relates to the original code?
If a color is in the correct slot, the codemaker responds with a black peg for that position. A white peg signals the correct color but wrong position. A blank indicates that neither position nor color are correct.

4. This next phase would consist of helping the player best interpret the responses of black, white and no pegs.
Regards,
Hayden Knox