Microsoft Office Forums - View Single Post - Using Conditional Formatting to identify duplicates

Thread: Using Conditional Formatting to identify duplicates

View Single Post

Old

05-23-2012, 04:57 PM

grizz

grizz is offline

grizz uses Windows XP

Windows XP grizz uses Office 2003

grizz uses Office 2003

Office 2003

Novice

Join Date: Jan 2012

Posts: 28

grizz is on a distinguished road

Default

highlight column A then conditional format / formula is
=ISNUMBER(MATCH(A1,B:B,0))

Reply With Quote