I have a conditional formatting rule for duplicate values:
D7 is looking for a duplicate from C2-C53 (one instance)
If duplicate exists D7 text turns red.
The problem: When I copy this cell and paste elsewhere the text color (red) does not follow. And yes, I have tried numerous options in paste special.
I have the same rule from D2 through D53.
Thank you in advance