Solved

Conditional Formatting question - Text Color - copy/paste

Posted on 2014-12-24
2
95 Views
Last Modified: 2014-12-27
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
0
Comment
Question by:dgd1212
2 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
Comment Utility
First, this is not a formula and cannot be used to find a match:
=$D$7,$C$2:$C$53

I presume that, instead, the conditional formatting formula for cell D7 is more like:
=MATCH($D$7,$C$2:$C$53,0)
or perhaps
=COUNTIF($C$2:$C$53,$D$7)

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.

Regards,
-Glenn
0
 

Author Closing Comment

by:dgd1212
Comment Utility
Thank you for the solutions
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now