HAI I WANT TO HELP... PLS HELP ANY ONE
I PUT THE NUMBER A1 1256 ,B1 2548, C1 8413, D1 7063, E1 5842 & F1 5216
A1 1256
F1 5216
B1 2548
E1 5842
ABOVE THE 4 DIGIT IS SAME BUT POSSITION IS DIFFERENT.
4 DIGIT IS SAME I WANT HIGHLIGHTS THE CELLS
HAI I WANT TO HELP... PLS HELP ANY ONE
I PUT THE NUMBER A1 1256 ,B1 2548, C1 8413, D1 7063, E1 5842 & F1 5216
A1 1256
F1 5216
B1 2548
E1 5842
ABOVE THE 4 DIGIT IS SAME BUT POSSITION IS DIFFERENT.
4 DIGIT IS SAME I WANT HIGHLIGHTS THE CELLS
Hello mkilakkiya,
I was hoping you would have responded and answered my question.
I have made a file (attached) showing the easiest way to highlight duplicates - Conditional Formatting. If you want to do it a different way let me know.
If this solves things for you, please mark my answer as selected.
Cheers :-)