Format duplicate values on multiple sheets

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.

dzparker89,

Welcome to the forum. Give the following a try:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar