+ Reply to Thread
Results 1 to 4 of 4

Compare Columns and highlight if criteria isn't met

  1. #1
    Registered User
    Join Date
    07-22-2021
    Location
    Minnesota
    MS-Off Ver
    office 365
    Posts
    2

    Compare Columns and highlight if criteria isn't met

    looking to compare columns and highlight if current inventory is lower than target.
    Attached Images Attached Images

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Compare Columns and highlight if criteria isn't met

    How do you compare 1 box to 300?

    Post a sample workbook. See the yellow banner at the top of the page.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    07-22-2021
    Location
    Minnesota
    MS-Off Ver
    office 365
    Posts
    2
    Quote Originally Posted by TMS View Post
    How do you compare 1 box to 300?

    Post a sample workbook. See the yellow banner at the top of the page.

    I attached a screenshot. You can see I want to compare Qty to Target. If Qty is equal or lower than target it will highlight the box for me.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,090

    Re: Compare Columns and highlight if criteria isn't met

    Suit yourself. I'm not going to create a worksheet from your picture so I can develop and test a solution for your problem.

+ 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. Replies: 2
    Last Post: 11-27-2016, 05:56 PM
  2. Compare two Columns and Highlight
    By Overclocker16 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 07-04-2015, 04:12 PM
  3. compare columns and highlight
    By Goodstart14 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2015, 12:45 PM
  4. Compare/Highlight Two Columns
    By mikayluh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-26-2015, 03:33 PM
  5. Compare Columns and Highlight
    By lkurrt in forum Excel General
    Replies: 2
    Last Post: 09-19-2013, 02:21 PM
  6. Compare 2 columns and highlight the new value,
    By fpolaco in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-07-2012, 02:22 PM
  7. Replies: 2
    Last Post: 01-26-2012, 12:04 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