+ Reply to Thread
Results 1 to 4 of 4

Help with a VLookup Formula in Conditional Formatting, multiple triggers

  1. #1
    Registered User
    Join Date
    10-15-2008
    Location
    West Des Moines, IA
    MS-Off Ver
    Excel 2007
    Posts
    40

    Help with a VLookup Formula in Conditional Formatting, multiple triggers

    Right now, I'm trying to come up with a one line entry that can cover three instances.

    Basically, I have a row of names in column F, and a reflection of scheduling in column G. I'm trying to write conditional formatting to flag a cell red if somebody is listed as OFF, TRAINING, or PTO. As opposed to writing in three separate formattings:

    =VLOOKUP(C2,$F$2:$G$12,2,0)="OFF"
    =VLOOKUP(C2,$F$2:$G$12,2,0)="TRAINING"
    =VLOOKUP(C2,$F$2:$G$12,2,0)="PTO"

    How would I combine that into one line? I'm sure it's just one silly punctuation, but my rote google searches are turning up nothing. The actual cell references are fairly irrelevant for my question, just representing where it's at. Any help would be appreciated. Thanks!
    Last edited by szm187; 02-02-2016 at 04:29 PM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Help with a VLookup Formula in Conditional Formatting, multiple triggers

    =or ( vlookup(c2,$f$2:$g$12,2,0)="off" , vlookup(c2,$f$2:$g$12,2,0)="training" , vlookup(c2,$f$2:$g$12,2,0)="pto")
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    10-15-2008
    Location
    West Des Moines, IA
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Help with a VLookup Formula in Conditional Formatting, multiple triggers

    Sorry for the late reply, was out of the office for a few days. That did the trick! More complex then I thought it would be (which makes me feel a little better), but fantastic nonetheless. Thanks!

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.84 (24041420))
    Posts
    8,751

    Re: Help with a VLookup Formula in Conditional Formatting, multiple triggers

    your welcome, thanks for the rep

+ 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] Vlookup formula to select and highlight (conditional formatting) multiple results
    By hbomb1927 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-20-2014, 03:27 PM
  2. [SOLVED] Formula for Multiple Criteria in Conditional Formatting
    By excelheaven in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-08-2013, 10:52 PM
  3. [SOLVED] Conditional formatting using multiple AND OR formula
    By edmcgregor in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 10-24-2012, 04:29 AM
  4. Replies: 2
    Last Post: 04-03-2012, 08:51 AM
  5. Replies: 5
    Last Post: 08-18-2011, 05:03 AM
  6. Replies: 2
    Last Post: 08-03-2006, 05:45 AM
  7. [SOLVED] Conditional formatting on cells with a VLOOKUP formula in them
    By JenniM in forum Excel General
    Replies: 4
    Last Post: 04-01-2005, 02:06 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