+ Reply to Thread
Results 1 to 3 of 3

Find criteria in range and mark the cellborders of found combination with color

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    2

    Find criteria in range and mark the cellborders of found combination with color

    Hello,
    I need a solution for the following task:

    I have a range of numbers in a table D13:U54, the numbers in the table are 0,1,2,3,4 and appear random,
    e.g.
    D13=1
    D14=1
    D15=1
    D16=2
    D17=2
    D18=2
    D19=1
    D20=1
    D21=3 etc.

    What I would like to achieve is to find and highlight the criteria that I choose eg. I would like to
    highlight all the combinations 1,2 or 1,1,1 or 2,1,1,3 etc. that appear in the range of my table.
    Hope my question is clear enough.
    Tanks,
    Osman

  2. #2
    Registered User
    Join Date
    10-09-2012
    Location
    Maldives
    MS-Off Ver
    Excel 2010
    Posts
    37

    Re: Find criteria in range and mark the cellborders of found combination with color

    Select Whole Table Go to Conditional Formatting Highlight cells Rules > Text that Contain > Type combination

    For more advance edit that one and put into one cell you can easy type and conditional will take u typed cell value


    Hope this will help u

  3. #3
    Registered User
    Join Date
    10-23-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Find criteria in range and mark the cellborders of found combination with color

    Hi Rasheed,
    Thanks for youre fast reply..
    However tried youre suggestion but unfortunately not what I want it to do.
    When I use conditional format it doesnt find a combination of numbers only one number is possible,
    and more advanced I used three cells with separate conditional formats but it separately highlights all possible numbers equal to
    the criteria eg. all 1 or all 2 etc. I would like it to only highlight the specific combination of the numbers I select...eg. 0 and 0 and 1 and so on.
    Thanks..
    Osman

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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