Matching two cells

[dave_br]

Is there a formula that will automaticlaly highlight any cells containing the same barcode?

will this be a conditional format?

my problem is i have a workbook of 1200 lines and dont really want to manually check them!

dave

 

[Gary McMaster]

If you sort the sheet by the bar code you could use the "Exact" function in a helper column as shown below.

Hope this helps.

Gary

Excel Workbook
	A	B
1	123abc	FALSE
2	456def	FALSE
3	abc456	FALSE
4	pqy789	TRUE
5	pqy789	FALSE
6	qbc123	FALSE
Sheet1

 

[Peter_SSs]

Dave

Yes you can certainly do this with Conditional Formatting, whether or not your data is sorted.

If you have Excel 2007+ select the column then Home ribbon|Conditional Formatting|Highlight Cells Rules|Duplicate Values...|OK
Format|Conditional Formatting...|Condition 1|Formula is:|

If you have an earlier version, select the data (A1:A7 for me) then Format|Conditional Formatting...|Condition 1|Formula is: =COUNTIF(A$1:A$7,A1)>1|Format>>|Fill tab|choose a colour|OK|OK

Excel Workbook
	A
1	123abc
2	456def
3	abc456
4	pqy789
5	qbc123
6	pqy789
7	456def
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	1. / Formula is =COUNTIF(A$1:A$7,A1)>1	Abc

 

[dave_br]

brilliant,

cheers guys, another couple of tricks up my sleeve!!

dave