+ Reply to Thread
Results 1 to 6 of 6

Need help getting this Conditional Formatting to work...

  1. #1
    Registered User
    Join Date
    08-05-2016
    Location
    Philadelphia, PA
    MS-Off Ver
    2013
    Posts
    24

    Need help getting this Conditional Formatting to work...

    Hello! I'm getting very frustrated with this

    I need to highlight changes in a table in sheet 1 if they are different than the table in sheet 2. Sheet 1's table live updates numbers and I want to show where new changes appear.

    If I have this table in Sheet 1:
    # Name Code
    1 Yellow PB-4
    1 Yellow PB-5
    1 Yellow PB-6
    2 Red PB-08
    3 Orange PB-11


    And this table in Sheet 2:
    # Name Code
    1 Yellow PB-4
    2 Red PB-08
    3 Orange PB-11

    I need PB-5 and PB-6 to be highlighted in the Yellow section, where they've been added.

    The problem I'm encountering is that if PB-05 is in the BLUE section in both tables, I would only want it to be highlighted where I added it to the yellow section - so the # and Name attached to the code also need to be accounted for in the formula.

    Can you help me before I pull all my hair out?

    Thank you!
    Meggo

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

    Re: Need help getting this Conditional Formatting to work...

    Use COUNTIFS on Name and Code columns to check if the combination exists in the Sheet1. If it's zero ( 0 ) then it's new and needs to be highlighted.
    Trevor Shuttleworth - Excel Aid

    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
    08-05-2016
    Location
    Philadelphia, PA
    MS-Off Ver
    2013
    Posts
    24

    Re: Need help getting this Conditional Formatting to work...

    What would that formula look like? Esp if they are in different sheets?

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,717

    Re: Need help getting this Conditional Formatting to work...

    Please post a sample file.

  5. #5
    Registered User
    Join Date
    08-05-2016
    Location
    Philadelphia, PA
    MS-Off Ver
    2013
    Posts
    24

    Re: Need help getting this Conditional Formatting to work...

    Here you are!

    Thanks a million!

    Meggo
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    16,717

    Re: Need help getting this Conditional Formatting to work...

    Using Trevor's method:

    Set CF formula in Sheet1 to:

    =COUNTIFS(Sheet2!B:B,$B2,Sheet2!C:C,$C2)=0
    Attached Files Attached Files

+ 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. Conditional Formatting does not work - HELP
    By djaime1 in forum Hello..Introduce yourself
    Replies: 3
    Last Post: 07-07-2014, 12:35 AM
  2. VBA & Conditional Formatting together won't work
    By blueturnaround in forum Excel Programming / VBA / Macros
    Replies: 32
    Last Post: 12-29-2012, 04:21 PM
  3. Replies: 1
    Last Post: 07-19-2012, 05:37 AM
  4. Conditional formatting does not work Please help
    By AB33 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-13-2012, 12:29 PM
  5. Conditional Formatting with Not work
    By fmluder93 in forum Excel General
    Replies: 4
    Last Post: 05-28-2009, 10:36 PM
  6. Conditional Formatting will not work
    By nada1 in forum Excel General
    Replies: 9
    Last Post: 12-28-2006, 03:34 PM
  7. Work around Conditional Formatting
    By Andy Chan in forum Excel General
    Replies: 3
    Last Post: 01-02-2006, 01:25 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