Home > Forum Home > Automating Data Analysis Tasks > Conditional Formatting Share

Conditional Formatting

Excel Help for Conditional Formatting in Automating Data Analysis Tasks


Forum TopicPost Reply Login

Conditional Formatting

Rate this:
(3/5 from 1 vote)
ConfusedHi,

I used the conditional formatting to compare 2 rows of customer account numbers to find duplicates.  This is the formula I used =(COUNTIF($E:$E,G1)=0)*(G1<>"")  I need to make another column with an X in it for the duplicates. Is there something I can add to the conditonal formula to do this? The list has over 10,000 customers. 
 Posted by on
 
Replies - Displaying 1 to 1 of 1Order Replies By: Most recent | Chronological | Highest Rated
Shocked
Rate this:
(3/5 from 1 vote)
Can you not make an IF formula in the new column that returns an X if the COUNTIF is above 1 then filter on non-blanks to return a unique list of duplicate customers?
 Excel Business Forums Administrator
 Posted by on
 Displaying page 1 of 1 

Excel templates and solutions matched for Conditional Formatting:

Solutions: Conditional Formatting Functions