I have a table of data with some repeated values across the rows:
I want to format the row so that only the second time the value is repeated the cell is highlighted:
Can I achieve this through conditional formatting?
Many thanks
Sara
Route | PAR | Start Time | Depot | D1 | D2 | D3 | D4 | D5 | D6 |
1 | PAR-00735076 | 03:00 Tue | DHLSTK | KIRKCALDY | EDINBURGH | DUNDEE | ABERDEEN | DUNDEE | ABERDEEN |
I want to format the row so that only the second time the value is repeated the cell is highlighted:
Route | PAR | Start Time | Depot | D1 | D2 | D3 | D4 | D5 | D6 |
1 | PAR-00735076 | 03:00 Tue | DHLSTK | KIRKCALDY | EDINBURGH | DUNDEE | ABERDEEN | DUNDEE | ABERDEEN |
Can I achieve this through conditional formatting?
Many thanks
Sara