Results 1 to 3 of 3

Alternate highlighting of duplicate values

Threaded View

  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    Thailand
    MS-Off Ver
    Excel 2007
    Posts
    34

    Alternate highlighting of duplicate values

    I'm making a workbook to keep track of inventory on FIFO basis, as such all deliveries are sorted into "lots" so that we can make sure the first lot to arrive is the first to leave. collum A has duplicates of almost every lot (as quantities sent for a product are almost always less that quantities recieved)

    basically collum A is as roughly as follows

    02-01
    02-01
    02-01
    01-03
    01-03
    01-02
    01-02
    01-02
    01-01

    I want to alternately shade entire row where duplicate value is found in cell

    02-01
    02-01
    02-01

    01-03
    01-03

    01-02
    01-02

    01-01

    Thanks!
    Last edited by exarranum; 02-25-2013 at 03:36 AM.

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