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

Thread: [Solved] Using Conditional Formatting to identify duplicates

View Single Post

Old

05-24-2012, 05:55 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

try this --- highlight column A then formula is
=countif($B$1:$D$1000,A1)
and format your colour

Reply With Quote