Dolesegofer
Technical User
I have a very large spread sheet with multiple columns of information. I have three columns of info that I want to look for duplicate entries.
Date Truck No. Gross Weight
Row 1 1-1-03 0001 82000
Row 2 1-1-03 0001 82000
Row 3 1-1-03 0001 82050
1-3-03 0002 82050
1-3-03 0002 82050
I want to format all entries with same date, same truck # and same weights.
I can get row one to format with the conditional formatting, but can't seem to get the right combination for row 2 and not row 3.
I would appreciate any help or thoughts anyone might have.
Thanks
Date Truck No. Gross Weight
Row 1 1-1-03 0001 82000
Row 2 1-1-03 0001 82000
Row 3 1-1-03 0001 82050
1-3-03 0002 82050
1-3-03 0002 82050
I want to format all entries with same date, same truck # and same weights.
I can get row one to format with the conditional formatting, but can't seem to get the right combination for row 2 and not row 3.
I would appreciate any help or thoughts anyone might have.
Thanks