+ Reply to Thread
Results 1 to 4 of 4

Conditional Formatting to match any combination of values against the correct set of value

  1. #1
    Registered User
    Join Date
    03-11-2015
    Location
    Oxfordshire
    MS-Off Ver
    Microsoft Office 365
    Posts
    3

    Conditional Formatting to match any combination of values against the correct set of value

    Hi there,

    I am trying to develop a results table whereby people can guess the first 5 places in a race. I then want to enter in the correct positions once the race has been completed and for it to show me who was correct and if anyone managed to guess all 5 positions correctly. I have tried to use Conditional Formatting to return the same values, but I do not want any formatting to be applied if the cells containing the correct positions are blank (before the race has finished).

    Below are the functions I want Excel to execute:

    - Highlight any single position somebody guesses correctly
    - Highlight the row when somebody gets all 5 positions correct
    - Work out how many points each person receives depending on how many positions they guess right

    Ideally I would like the highlighting of the cells to use Conditional Formatting and to not require any other data being entered (ie. a CONCATENATE formula), but this is just an ideal.

    Any help would be greatly appreciated, I have attached a screenshot of the layout of the results table.

    Thanks!

    Sweepstake.jpg

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,343

    Re: Conditional Formatting to match any combination of values against the correct set of v

    Hi and welcome to the forum.

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
    Few of us are prepared to recreate a workbook from a picture when you have one available.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-11-2015
    Location
    Oxfordshire
    MS-Off Ver
    Microsoft Office 365
    Posts
    3

    Re: Conditional Formatting to match any combination of values against the correct set of v

    Hi Richard,

    My apologies, I was hardly expecting someone to create my workbook from scratch! I have attached the file in question.

    Thanks!
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-11-2015
    Location
    Oxfordshire
    MS-Off Ver
    Microsoft Office 365
    Posts
    3

    Re: Conditional Formatting to match any combination of values against the correct set of v

    Hi all,

    I have managed to solve my issues and now have a good results table to highlight winners, automatically add up awarded points and mark the top 5 places.

    The only thing that would be good to quickly see is whether or not any two people have exactly the same guesses for the race outcome.

    Is there a way to do this so that blank cells are ignored even when there aren't any duplicate guesses..? With Conditional Formatting if possible?

    I have attached a simple excel document with some mock data, including one set of duplicates and some blank cells (as not everyone listed will necessarily want to play).

    Sweepstake.xlsx

    Thanks!

+ 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. Extending conditional formatting in combination met merged cells
    By jackhays in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-10-2015, 09:24 AM
  2. Conditional formatting isn't correct for some cells
    By daviddaich in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2014, 05:43 PM
  3. Conditional formatting triggered by inital and date combination
    By jw123 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2013, 11:03 PM
  4. Need help with data validation, conditional formatting combination and more...
    By IsiEMT in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-13-2011, 11:34 PM
  5. Replies: 1
    Last Post: 07-13-2011, 09:22 AM

Tags for this Thread

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