Excel 2007 : Identify multiple duplicates and color

Hi all

Great forum. Have had great help from the forums but are stumped with a issue

I need to compare column D with column E to identify duplicate serial numbers and color the duplicate cell. (only in column D) with a formula and or macro. (I do not mind using a helper column if formula can be used)

Thank u in advance

Dettrix

Hello Dettrix
Select column D range and using Conditional Formatting from the Ribbon menu, apply conditional formatting formula with: New Rule > 'Use a formula to determine which cells to format':

=COUNTIF($E$2:$E$442,D2)

Hope this helps.
DBY

Thanx, will try it.