• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 123
  • Last Modified:

Conditional Formatting question - Text Color - copy/paste

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
1 Solution
Glenn RayExcel VBA DeveloperCommented:
First, this is not a formula and cannot be used to find a match:

I presume that, instead, the conditional formatting formula for cell D7 is more like:
or perhaps

In any case, if you remove the absolute referencing around $D$7 in whatever formula does exist (i.e., remove the dollar signs so it just says "D7"), you should be able to then copy this formula up/down column D as needed.

dgd1212Author Commented:
Thank you for the solutions
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now