Search:

Yes that works for duplicates within the page but i want the cell to change colour if the data is duplicated on the previous worksheet

For example i would like ITEM NO 4-011511 to be highlighted...

I have one query regarding the Microsoft excel. I have one excel file with multiple sheets.

What i want to do is -

- Highlight any values (in colour) on the current sheet that I'm in
- which...