excel conditional formatting icon sets for duplicate values

Iron Contributor

I would like to display an Arrow on the cell above the cell wherever a duplicate value is found in a specified range. How can I achieve this?

1 Reply
You can achieve this by countif formula with conditional formatting..