Hello-

I need a macro that can search for duplicates in 4 different worksheets, (Week1, Weel2, Week3, Week4), in cells E2:E30. If there are duplicates, I need the text to be highlighted red. Essentially what I need is conditional formatting based on duplicate values, except I don't think you can conditionally format ranges on different worksheets. Is this possible to do with a macro? Is there an easier way to solve this problem?

Thanks.