Using Conditional Formatting to identify duplicates

		Microsoft Office Forums > Microsoft Excel > Excel
Using Conditional Formatting to identify duplicates

05-24-2012, 05:55 PM

grizz

Windows XP Using Conditional Formatting to identify duplicates

Office 2003

Novice

Join Date: Jan 2012

Posts: 28

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting.	Laurie B.	Excel	6	04-09-2012 05:01 PM
Conditional formatting	zanat0s	Excel	4	01-20-2012 03:30 AM
Conditional formatting with AND, OR	Lucky	Excel	2	10-03-2011 11:41 PM
Conditional Formatting	namedujour	Excel	3	08-25-2011 01:46 PM
help with conditional formatting	Snvlsfoal	Excel	3	07-03-2011 11:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:00 AM.