Hello Everyone,
I have a column of data, and I want to Hilight duplicate by conditional formatting based on each two rows and not for all columns, For example :
Screenshot (114).png
As showd on above image, the function must compare pairwise cells (even and odd rows) together, for example at this column A4 and A5 cells are duplicates so they were hilighted, A10 and A11 are duplicates so they were hilighted ....
I hope that you understand me.
Is it possible to do via Conditional formatting ?
Bookmarks