-
Highlighting all row with same date
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 |
|
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules