PDA

View Full Version : Highlighting all row with same date



oam
12-08-2015, 06:06 PM
I needed a formula to work in Conditional Formatting to highlight all rows of data with the same date.
I use a macro to copy tracking numbers from a worksheet to a database. Each tracking number is on a row with the date in column A and there can be over twenty to thirty in a business days’ time. The users have requested each row of data with the same date be highlighted by date to make it easier to find information when needed.

The ideal result would be, row 1 – 3 would be highlight with a color and row 4 – 7 would not be highlighted or another color.




A

B

C



1

7/29/2015

1ZX29W000199590000

1ZX29W000199158393



2

7/29/2015

1ZX29W000198010000

1ZX29W000199419173



3

7/29/2015

1ZX29W000199474000

1ZX29W000197027162



4

7/31/2015

1ZX29W000194102000




5

7/31/2015

1ZX29W000192820000




6

7/31/2015

1ZX29W000199520000




7

7/31/2015

1ZX29W000194035000