Generate random numbers and highlight those numbers in spreadsheet.

[Johncobb]

In my spreadsheet I have many rows of 40 numbers in each row (numbers between 1 and 80 in each row).
I want to generate 20 random numbers between 1 and 80 and then to check if they come up in each row (each row has 40 numbers between 1 and 80).
The numbers that came up should be highlighted in each row in a color so I will be able to see which numbers and how many numbers did come up after each random spin.
I hope that you understand what I mean. This is a short description. Please contact me if you need more explanations.
Waiting for comments and advice.
John

 

[Johncobb]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Hello,
You are the moderator? I have a question.
I want to mark 2 helping members a solution because both have helped me. I can not do it? WHY?
I marked Joe4 as solution and I wanted also mark Rick Rothstein because his answer helped me and his suggestion also worked.
I think that marks as solution should be allowed to be assigned to more than one member or one answer. Don't you think so?
Best regards,
John

 

[Johncobb]

I am glad that the last answer seemed to work for you.

However, in marking the "Solution" to the question, please mark the post that answered your original question, not the follow-ups.
Could you go back and mark the solution that you used for the original question you asked?

Thanks

I don't know what you mean.
Do I have to mark the specific answer or specific post that solved my problem?

 

[Joe4]

Hello,
You are the moderator? I have a question.
I want to mark 2 helping members a solution because both have helped me. I can not do it? WHY?
I marked Joe4 as solution and I wanted also mark Rick Rothstein because his answer helped me and his suggestion also worked.
I think that marks as solution should be allowed to be assigned to more than one member or one answer. Don't you think so?
Best regards,
John

Unfortunately, that is not an option with the board software we are using.
You will just need to mark the post that most helped you solved your original question.
However, you can "Like" all the posts that helped you.

 

[Joe4]

I don't know what you mean.
Do I have to mark the specific answer or specific post that solved my problem?

Yes, that is the idea.