Hi
I have a sheet that contains all the activities and products logged against individual projects which vary in number per project (so far anywhere between 4 and 20 items per project)
I need to be able to highlight (conditional formatting) the duplicate items logged to any individual project.
For example
Column 1 Column 2
Project 1 Survey
Project 1 Design
Project 1 Design <--- Duplicate
Project 2 Survey
Project 2 Survey <----Duplicate
Project 2 Design
Project 2 Widgets
Any assistance gratefully recieved
Hi Dave
Try this.
Sunny
That works - and so simple.
Thank you SunnyKow
Hi
i have a horizontal duplicate date, could you please help me for how to update conditional formatting.
A1 B1
Apple Apple
Orange Cherry
Kiwi Kiwi
1 1
2 7
8 8
Hi Mohamed
See if this is what you wanted.
Sunny
yes it is what i need, and thanks for your support.
