Hi,
I'm not sure if it is entirely possible, but I hope somebody can help if it is.
I am currently running a reviews campaign for my company, and looking to highlight cells where the person has shown up more than once, and already left a review.
My excel sheet is large, and going to continue growing, so it may be difficult to look back and see if we have already had a review back from somebody who has left feedback previously.
On the attachment you should see that there is a list of people who have given us feedback (not the real names), and some have given feedback more than once. For example, Clyde has left a review already, so I want to see if we can highlight the duplicate value in red to show that Clyde has already left a review after previous feedback. In comparison, I want it to be left blank if the person is a duplicate value after leaving previous feedback, but has not left a review like with Faye. So that I can message Faye again for her review whilst leaving Clyde out.
I don't mind if there needs to be a different column or anything added, I am just hoping for an easy way to see if somebody has already given a review. Also, it doesn't need to be highlighted if it doesn't work like that - happy with anything!
Please let me know if you know any way this can be done
Bookmarks