Results 1 to 9 of 9

Conditional Formatting using VLOOKUP

Threaded View

  1. #1
    Registered User
    Join Date
    05-28-2009
    Location
    Oxford
    MS-Off Ver
    Excel 2007
    Posts
    86

    Conditional Formatting using VLOOKUP

    I want to monitor if a status has changed on Sheet1 between two columns - but only unexpected changes.

    I have a list on Sheet2 with column A containing original status and column B containing a list of changes the status could expect to make.

    I know a named range has to be used because sheet referencing doesn't work for conditional formatting.

    So I've been using this in the conditional formatting:

    =VLOOKUP(B2,change,2,0)=A2

    "change" refers to the named range of the two columns described on Sheet2.

    As you can see from the attached, 'Limp' has been correctly identified as unexpected, 'Leap' and 'Hike' are expected and should not be highlighted, and 'Fall' at the bottom should also be highlighted but is not.

    vlookupCF.xlsx
    Last edited by Knawl; 08-07-2014 at 12:17 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Using conditional formatting with vlookup
    By benno87 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-27-2008, 09:49 PM
  2. IF and VLOOKUP conditional formatting
    By penfold in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2008, 07:05 AM
  3. VLOOKUP in Conditional Formatting
    By Brokovich in forum Excel General
    Replies: 5
    Last Post: 01-19-2007, 01:02 PM
  4. Conditional formatting & Vlookup
    By Jean-Paul Hahn in forum Excel General
    Replies: 6
    Last Post: 01-24-2006, 05:40 PM
  5. [SOLVED] vlookup & conditional formatting
    By Emma in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-23-2005, 11:06 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