Is it possible to highlight duplicate cells in ROWS only whereby any text or numeric value is highlighted?
So in the below table
Row 1 - nothing highlighted
Row 2 - Cat highlighted
Row 3 = 555 highlighted (ignores 55)
Row 4 = Both Cat and 555 highlighted
So in the below table
Row 1 - nothing highlighted
Row 2 - Cat highlighted
Row 3 = 555 highlighted (ignores 55)
Row 4 = Both Cat and 555 highlighted
A1000 | Lee | Steve | Darren | Martin | 333 | 445 |
A1001 | Cat | Dog | Cat | Rabbit | Zebra | Seahorse |
444 | ef | gfd | 555 | dfsdf | 55 | 555 |
444 | Cat | gfd | 555 | Cat | 55 | 555 |
Last edited: