Results 1 to 22 of 22

Rank, select, conditional format

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-19-2012
    Location
    Tacoma, Washingtonn
    MS-Off Ver
    Excel 2019
    Posts
    334

    Rank, select, conditional format

    Greetings all. I have an interesting puzzle I am hoping someone can help me with. I have attached an abbreviated version of the chart I use. What I am specifically trying to do is:

    1. In each block of 4 numbers, identify the smallest number in column #1 first.
    2. That number is then added to the smallest number in column #2 to get the proper result.

    RULES:

    1. The smallest number which is used in column #1 cannot be added to a number adjacent to it in column #2. The smallest number among the remaining 3 numbers in column #2 must be used.
    2. If 2 or more numbers in column #1 are the smallest, use any one that is not adjacent to the smallest number in column #2, so the smallest possible number in column #2 may be used.
    3. The goal is to achieve the smallest result.
    4. I hope to be able to apply conditional formatting to highlight those cells used to reach the result. I have tried using helper columns/cells, but I get overwhelmed.

    I hope this makes sense and my explanation is not terribly confusing. I have always had tremendous luck in the forum. Thanks in advance for any help you can provide.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Rank a set of cells and conditional format them to certain rules
    By khanaran in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-13-2020, 07:55 AM
  2. Conditional format to rank number of occurrences of alpha value
    By geobeck in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-21-2015, 11:48 AM
  3. Select and colour cell depending on rank of number (macro conditional formatting)
    By mrpwebb in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2014, 03:59 PM
  4. Replies: 2
    Last Post: 04-18-2009, 02:35 AM
  5. Select specif range on Conditional Format
    By robotlust in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2008, 01:51 AM
  6. Conditional Format Rank query
    By Rich in forum Excel General
    Replies: 3
    Last Post: 06-12-2006, 02:43 PM
  7. Replies: 1
    Last Post: 08-15-2005, 05:05 PM

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