<div>
Thank you for the solutions
</div>


<div>
<div class="content wysiwyg-content">
I have a conditional formatting rule for duplicate values:<br />
=$D$7,$C$2:$C$53<br />
D7 is looking for a duplicate from C2-C53 (one instance)<br />
If duplicate exists D7 text turns red.<br />
<br />
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.<br />
<br />
I have the same rule from D2 through D53. <br />
<br />
Thank you in advance
</div>
</div>


I have a conditional formatting rule for duplicate values:
=$D$7,$C$2:$C$53
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

Conditional Formatting question - Text Color - copy/paste

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.