+ Reply to Thread
Results 1 to 2 of 2

Conditional Format the first x matching results?

  1. #1
    Registered User
    Join Date
    08-31-2016
    Location
    South Dakota
    MS-Off Ver
    2016
    Posts
    10

    Conditional Format the first x matching results?

    This is stumping me a bit.

    A coworker asked me if it was possible to apply conditional formatting to her workbook. She does not want to add any formula/reference columns or rows.

    Column A: a list of part numbers
    Column B: quantity of those part numbers in stock (this is x)

    Columns C-T (possibly more) list of part numbers required for a build

    What she is asking is for conditional formatting to look through the C-T range and to highlight the first x amount of parts, referencing Column A for the part number and Column B for the number of items to highlight.

    So if cell A1 = 12345 and cell B1 = 5, it would look through Columns C-T and only highlight the first 5 instances of "12345".

    Is this even possible with conditional formatting or would this be more of a VBA thing?

  2. #2
    Forum Expert
    Join Date
    09-25-2015
    Location
    Milan Italy
    MS-Off Ver
    office 365
    Posts
    1,783

    Re: Conditional Format the first x matching results?

    Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

+ 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] vba to conduct a conditional format for matching first and last names in two columns?
    By lilsnoop in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-07-2020, 07:42 PM
  2. [SOLVED] Conditional Format Matching one of several choices
    By Stryfe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2018, 01:40 PM
  3. [SOLVED] Conditional Format one cell in a row based on a value matching a header row
    By purdue7997 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-16-2017, 09:18 AM
  4. [SOLVED] Conditional Format Based on Matching or Not of First 3 Letters of another Column
    By excel2425 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2017, 01:13 PM
  5. [SOLVED] Display Conditional Format Colour in VLOOKUP Results
    By gtudor in forum Excel General
    Replies: 2
    Last Post: 03-20-2014, 05:58 AM
  6. Excel 2007 : Conditional Format on matching ID's
    By party4one in forum Excel General
    Replies: 2
    Last Post: 01-04-2011, 09:57 AM
  7. [SOLVED] Conditional Format matching Dates,calendar
    By ufo_pilot in forum Excel General
    Replies: 3
    Last Post: 07-31-2006, 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