+ Reply to Thread
Results 1 to 5 of 5

No match conditional formatting

  1. 08-30-2017, 09:32 AM #1
    gz3s36
    gz3s36 is offline
    Forum Contributor
    Join Date
    02-06-2014
    Location
    The Show Me State
    MS-Off Ver
    Excel 2013
    Posts
    343

    No match conditional formatting

    Looking for formula to highlight cell in Q if V can’t be found in H:H
    Reply With QuoteRegister To Reply
  2. 08-30-2017, 10:02 AM #2
    PFDave
    PFDave is offline
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: No match conditional formatting

    Highlight all of column G and use this:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Please do add reputation where you see fit, it's nice to be nice and we all enjoy a pat on the back

    Please also mark your thread as solved once it has been.
    Reply With QuoteRegister To Reply
  3. 08-30-2017, 10:05 AM #3
    PFDave
    PFDave is offline
    Valued Forum Contributor PFDave's Avatar
    Join Date
    05-17-2012
    Location
    Milton Keynes, England
    MS-Off Ver
    Excel 2013
    Posts
    1,067

    Re: No match conditional formatting

    Or:

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 08-30-2017, 10:07 AM #4
    sweep
    sweep is offline
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,445

    Re: No match conditional formatting

    Hi,

    Assuming when you say Q and V you mean the columns, with Q:Q selected and Q1 active, use this formula,

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
    Reply With QuoteRegister To Reply
  5. 08-30-2017, 10:10 AM #5
    gz3s36
    gz3s36 is offline
    Forum Contributor
    Join Date
    02-06-2014
    Location
    The Show Me State
    MS-Off Ver
    Excel 2013
    Posts
    343

    Re: No match conditional formatting

    Thanks sweep. That seemed to do the trick.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formatting with INDEX MATCH MATCH
    By jawebb in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 04-28-2016, 05:01 AM
  2. 3 way match with conditional formatting
    By JBur in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-26-2015, 09:28 AM
  3. How to use conditional formatting with multiple match
    By nobody123 in forum Excel General
    Replies: 2
    Last Post: 08-21-2013, 01:52 AM
  4. Conditional Formatting with INDEX/MATCH
    By Shanster695 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-22-2013, 02:39 PM
  5. Conditional formatting to match row numbers
    By mtouhig in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-03-2012, 05:58 PM
  6. Match and conditional formatting
    By murray_g in forum Excel General
    Replies: 3
    Last Post: 05-10-2007, 07:12 PM
  7. Match words - Conditional Formatting
    By KH_GS in forum Excel General
    Replies: 7
    Last Post: 03-29-2006, 07:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1