Results 1 to 4 of 4

Duplication in rows condional formatting

Threaded View

  1. #1
    Registered User
    Join Date
    01-25-2010
    Location
    BURTON ON TRENT, UK
    MS-Off Ver
    Excel 2003
    Posts
    34

    Duplication in rows condional formatting

    Hi Forum,

    Looked though previous posts, but cannot solve my problem.

    I have spreadsheet that i need to highlight duplicate rows with CF ideally. All Cells need to match across all columns(A-AB) to qualify as duplicate.For me its a made tricky cuz the sheet has 31000 rows.

    I have completed unique filter and saved result but need to show duplicates. The main aim is to keep the sheet in same order to present back to client .

    Any suggestions would be a great help.

    Thanks in advance
    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