+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting between 2 sheets

  1. #1
    Registered User
    Join Date
    10-05-2009
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    76

    Conditional formatting between 2 sheets

    I have a question about conditional formatting.

    I have 2 sheets in the same workbook. One is titled "Paste Oldest Here" and the other is titled "Paste Newest Here".

    Each sheet has 6 columns of data.

    I am looking for a way to highlight an entire rows in "Paste Newest Here" when the ID number in Row A on this sheet IS NOT found in "Past Oldest Here" Row A.

    Basically, I just need to highlight the NON DUPLICATES on "Paste Newest Here" when compared to "Paste Oldest Here".

    There are a few blanks and I would like this formatting to happen without having to sort prior.

    Your assistance would be greatly appreciated as usual!

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Conditional formatting between 2 sheets

    Hi,

    in sheet "Paste Oldest Here" select your IDs in column A and assign a range name, for example OldestCodes.

    On the other sheet select all your cells, then enter a conditional formatting rule with this formula

    =ISNA(MATCH($A1,OldestCodes,0))

    Select a format and you're good to go.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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