Conditional Formatting

Excel Help for Conditional Formatting in Automating Data Analysis Tasks

Conditional Formatting

Rate this: (3/5 from 1 vote)

	Hi, 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 BridgetteNelson on 17 Nov 2007

Replies - Displaying 1 to 1 of 1

Order Replies By: Most recent | Chronological | Highest Rated

	An IF Statement with a filter 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 Excel Helper on 19 Nov 2007

Displaying page 1 of 1