Results 1 to 11 of 11

Conditional Formatting/Duplicates

Threaded View

  1. #1
    Registered User
    Join Date
    03-19-2009
    Location
    Houston, TX
    MS-Off Ver
    Excel 2003
    Posts
    5

    Conditional Formatting/Duplicates

    Hello all,
    My background is many years of Access VBA. From time to time, I'm called upon to work in Excel. I am not that familiar with the library.

    I'd like to know if it is possible to do the following:

    Examine Column 1 and, for each like value, examine Columns 2 and 3 for duplicate values. Highlight or conditionally format the duplicates in Columns 2 and 3 (again, for each like value in Column 1).

    Being that I've coded Access applications for quite some time, I am sure it can be done...I just don't yet know exactly how. I've searched the archive for and found some examples which deal with duplicate data, but have found none yet which quite fit my scenario.

    Could someone help me out, please?

    I will continue searching the many threads matching my keywords in the meantime.

    Many thanks.

    Oh, sorry to impose even more...I've found sample code which enforces rules and conditionally formats cells when new data is added. It works fine and I understand it. I'm hoping the kind soul who might help me with the above can explain how I might do both things on the code page.

    I assume the Worksheet_Change Event would contain the "enforcement" code.
    Attached Files Attached Files

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