+ Reply to Thread
Results 1 to 18 of 18

cell change on certain conditions

  1. #1
    Registered User
    Join Date
    03-06-2014
    Location
    chichester
    MS-Off Ver
    Excel 2007
    Posts
    44

    cell change on certain conditions

    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

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,852

    Re: cell change on certain conditions

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

    BSB

  3. #3
    Registered User
    Join Date
    06-23-2019
    Location
    United States
    MS-Off Ver
    Outlook
    Posts
    6

    Re: cell change on certain conditions

    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.

  4. #4
    Registered User
    Join Date
    06-23-2019
    Location
    United States
    MS-Off Ver
    Outlook
    Posts
    6

    Re: cell change on certain conditions

    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.

  5. #5
    Registered User
    Join Date
    03-06-2014
    Location
    chichester
    MS-Off Ver
    Excel 2007
    Posts
    44
    Quote Originally Posted by BadlySpelledBuoy View Post
    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

  6. #6
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,852

    Re: cell change on certain conditions

    Quote Originally Posted by joespencerno1 View Post
    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.

  7. #7
    Registered User
    Join Date
    03-06-2014
    Location
    chichester
    MS-Off Ver
    Excel 2007
    Posts
    44

    Post Re: cell change on certain conditions

    it wont let me load an attachment file?

  8. #8
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,852

    Re: cell change on certain conditions

    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

  9. #9
    Registered User
    Join Date
    03-06-2014
    Location
    chichester
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: cell change on certain conditions

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

  10. #10
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,852

    Re: cell change on certain conditions

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

    BSB

  11. #11
    Registered User
    Join Date
    03-06-2014
    Location
    chichester
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: cell change on certain conditions

    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
    Attached Files Attached Files
    Last edited by joespencerno1; 06-24-2019 at 11:03 AM.

  12. #12
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,852

    Re: cell change on certain conditions

    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

  13. #13
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,852

    Re: cell change on certain conditions

    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

  14. #14
    Registered User
    Join Date
    03-06-2014
    Location
    chichester
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: cell change on certain conditions

    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

  15. #15
    Registered User
    Join Date
    03-06-2014
    Location
    chichester
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: cell change on certain conditions

    Any Luck at all BSB?
    Joe

  16. #16
    Registered User
    Join Date
    03-06-2014
    Location
    chichester
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: cell change on certain conditions

    Ok I guess you didn't understand me

  17. #17
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,348

    Re: cell change on certain conditions

    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.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  18. #18
    Registered User
    Join Date
    03-06-2014
    Location
    chichester
    MS-Off Ver
    Excel 2007
    Posts
    44

    Re: cell change on certain conditions

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change a cell's font color based on conditions
    By Grilleman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2019, 10:20 AM
  2. make cell blink and/or change colors under certain conditions
    By hkbhansali in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2017, 09:55 AM
  3. [SOLVED] Change pattern based on cell value (Multiple conditions)
    By amein in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-10-2016, 05:28 AM
  4. Upon entry in any cell, need some fill colors to change if certain conditions met
    By ILoveStMartin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2014, 02:25 AM
  5. [SOLVED] Confirmation Popup Window on Cell Change & Cell Delete. (3 conditions)
    By smk224 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-12-2013, 02:51 PM
  6. Background of cell to change depending on two conditions
    By cdmg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2010, 11:17 AM
  7. Help for a macro change cell colour under many conditions
    By dpjim in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-12-2005, 08:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1