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

Thread Tools
Show Printable Version Email this Page Mark this thread as solved
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 11:36 AM.