cell change on certain conditions

[joespencerno1]

Hello all

I am stuck and need some help.

basically I have made a 90 ball bingo RNG with a ticket checker, it has a 1-90 grid and a current number that has been last called in another cell. the ticket checker comes from another tab with a long list which is picked up by a "VLOOKUP" which is activated by a active x command button which asks for the ticket number and pastes that number into another cell for the "vlookup" reference.
what I need the spreadsheet to do is determine if a win is correct ie: 1 line, 2 lines and house and change what is being played again ie: 1 line, 2 lines and house in cell "A1" to change automatically to state what is being played

a little difficult to explain, if you think you can help please do so lol
many thanks
in advance
joe

[BadlySpelledBuoy]

Could you attach what you have so far? It may make a little more sense if we can see it in context.

BSB

[evelynharper]

If I understand you correctly, it won’t matter that some cells in the conditional formatting range are determined by other cells. It’s what is in that range that is used in the conditional formatting. If this is not the correct understanding, please be clearer or suggest an example.

[evelynharper]

If you are looking to sum or count the contents of different cells you can use criteria to filter our the cells you want to omit. You can do this using: SUMIF (allows 1 criteria) or SUMIFS (allows multiple criteria) if you want to return the sum all cells matching your criteria COUNTIF (allows 1 criteria) or COUNTIFS (allows multiple criteria) to count the number of cells which correspond to your criteria SUMPRODUCT (allows multiple criteria) and can be used to sum or count using criteria There are plenty of good resources where you can learn how to use those functions (with relevant examples as well). All you need to do is understand what you are trying to achieve and what function to use from the ones mentioned above.

[joespencerno1]

Could you attach what you have so far? It may make a little more sense if we can see it in context.

BSB

I will attach the spreaadsheet if i can or screen shots of it tomorrow
Thanks for your reply

[BadlySpelledBuoy]

I will attach the spreaadsheet if i can or screen shots of it tomorrow

Please can we have the file rather than pics of it? They often serve little use in providing you with a solution and nobody wants to go through the headache of recreating what you have in front of you already. Ta.

BSB.

[joespencerno1]

it wont let me load an attachment file?

[BadlySpelledBuoy]

Click on "Go Advanced" below your reply then scroll down and click where it says "Manage Attachments". That will open the upload window and should be straightforward from there.

If the file exceeds the size limit then create a slimmed down version and attach that.

BSB

[joespencerno1]

I did that but still wont let me attach the file, I have uploaded it via manage attachments.

[BadlySpelledBuoy]

Then perhaps the file it too big and you'll need to make a slimmed down version to upload.

BSB

[joespencerno1]

just noticed its there lol

there is a sheet missing as had to delete that sheet in order to attach the file, its the sheet that picks up the ticket numbers for a ticket check

[BadlySpelledBuoy]

Click "Go Advanced"
Click "Manage Attachments"
Click where it says "Browse"
Navigate to the file
Select the file
Click "Open"
Click "Upload"
Click "Close This Window"
Write your message
Click "Submit Reply"

BSB

[BadlySpelledBuoy]

OK, we got there eventually.

Now all we need to know is exactly what you want it to do and if that sheet you deleted is important in providing a solution!

Could you elaborate a little. I'm not sure from your OP that I understand the requirement here at all.

BSB

[joespencerno1]

ok I hope you understand how bingo works when
you click "GENERATE" a random number will appear in the "Current number" cell and in the 1-90 grid. when you click on "CHECK CLAIM" it will ask for a ticket number the VBA will paste that number into cell ("U6")
the 9x9 grid below will pick up that number ticket from the number list (which I had to delete) and the grid will copy those numbers with a "VLOOKUP" (which you can see in the formula bar.

what I need it to do...
in cell ("F1") I need it to cycle between "ONE LINE", "TWO LINES" & "FULL HOUSE" when a winner has been found for each cycle
for example if a line winner is found, when the generate button is next clicked for the next number it will switch to "TWO LINES"
and then same scenario for the full house.
im not sure if this is possible but I thought that the forum would be my best bet
cheers
joe

[joespencerno1]

Any Luck at all BSB?
Joe

[joespencerno1]

Ok I guess you didn't understand me

[AliGW]

Obviously not, but how about looking at it the other way around: NOBODY has helped, so maybe your explanation of what you want is not clear?

Try again - take it step-by-step - illustrate what you are expecting.

[joespencerno1]

its all good I figured it out thanks for everyone for trying to help though
much appreciated
joe