I work with a spreadsheet that has hundreds of rows and numerous columns. Sometimes I accidentally duplicate the same number in more than 1 cell in a row. I know how to use conditional Formatting to highlight duplicates across a range of columns, but need to just highlight the duplicates in a row (for all the rows). E.G:
Row 1: 03,45,22,50,45,60
Row 2: 55,12,08,55
Etc...
As you can see, in Row 1, I've got the number '45' in twice, so would like to highlight this row as having a duplicate. The same for row 2 with the number '55'.
I usually have around 800 rows and 20 columns, so doing each row individually isn't an option. I'm sure there must be a way.
Thanks for your help!
Bookmarks