Results 1 to 3 of 3

Conditional format using formula that contains VLookup

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Australia
    MS-Off Ver
    Excel 2016
    Posts
    334

    Conditional format using formula that contains VLookup

    I have a set of data in A:P
    I have a named range "TR" in which I need to look up a value

    I would like to conditionally format Columns M:P if the value in the cell is less than a value in the lookup table
    Column M corresponds with the 2nd column of the lookup table
    Column N corresponds with the 3rd column of the lookup table ETC

    My formula would be:

    if M2 < Vlookup(b2&g2,TR,2,false) then conditional format
    if N2 < Vlookup(b2&g2,TR,3,false) then conditional format

    etc for Columns O and P

    I have attached a sample workbook.
    Any assistance appreciated.

    Thanks again.
    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. How to conditional format cells based on vlookup/match formula
    By dougebowl in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-21-2013, 06:50 PM
  2. [SOLVED] conditional format based whether VLOOKUP finds a value
    By merlyn45 in forum Excel General
    Replies: 3
    Last Post: 05-14-2012, 02:42 PM
  3. Conditional Format & Vlookup Error!
    By fugro in forum Excel General
    Replies: 12
    Last Post: 02-21-2011, 11:53 PM
  4. Using Vlookup in Conditional Format
    By melnikok in forum Excel General
    Replies: 4
    Last Post: 12-10-2008, 03:21 PM
  5. [SOLVED] VLOOKUP in a conditional format
    By Russell Brown in forum Excel General
    Replies: 3
    Last Post: 08-03-2006, 02:15 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