Conditional formating maybe? (Stuck)

[CyannideHigh]

Hey there guys (And Girls),

I have a problem i just can't solve, ok here it is i have 2 sheets within my document that will have a VERY similar list in them. i would really like to see if i am putting in duplicates in either list without having to jump back and forth.

I was personally thinking conditional formatting but i don't know how to get both columns selected without excel "arguing" with me about it XD

Any ideas?

Thanks in advance

 

[James006]

Hello again,

We will assume ' next to them ' means Column A ...

Test following formula .

=AND($A2="Y",ISNUMBER(MATCH($B2,stock_checker,0)))

HTH

 

[Fluff]

How about
=AND(ISNUMBER(MATCH(C2,master!$C$2:$C$100,0)),master!B2="Y")

 

[CyannideHigh]

I'll check them both out and keep you posted

 

[CyannideHigh]

Ok so... both work, problem is that it doesn't cross-match each one to the name now it only "looks" at the first entry and sees the "Y" so everything is true XD

 

[Fluff]

With a master sheet like

Excel 2013/2016
	B	C
2	Y	AL4 0AA
3	Y	AL4 0BW
4	Y	AL4 0XX
5	Y	AL4 9XZ
6	Y	AL4 9YL
7	Y	AL5 2PR
8	Y	AL5 5FG
9		AL5 5UG
10	Y	AL5 5UN
11		AL6 0PB
12		AL6 0PE
13	Y	AL6 9TU
14		AL6 9UG
15	Y	AL6 9UJ
master

and on the sheet with the CF

Excel 2013/2016
	C
2	AL4 0AA
3	AL4 0BW
4	AL4 0XX
5	AL4 9XZ
6	AL4 9YL
7	AL5 2PR
8	AL5 5FG
9	AL5 5UG
10	AL5 5UN
11	AL6 0PB
12	AL6 0PE
13	AL6 9TU
14	AL6 9UG
15	AL6 9UJ
Sheet1

 

[CyannideHigh]

Something very similar, but it is bringing up false positives

if i could send it you i really would because it's driving me nuts now XD

 

[James006]

Ideally ... why don't you post a sample file to Dropbox or Google Drive ... :wink:

 

[CyannideHigh]

https://www.dropbox.com/s/vo6azivfy0d1sei/Mine Quest 2 (PC).xlsx?dl=0

This is everything i got so far... if you check out the "gear" Tab and scroll down a little you will see in $B:$B there are a few things maked "H",
Then go over to the "Evo" tab and the things maked with the "H" are still flagging up

 

[James006]

Great ... !!!

So the Tab named ' Gear ' contains your Master List in Column C ...

By the way the formula to create the Name ' Master ' should be :

=OFFSET($C$1,1,0,COUNTA($C:$C)-1,1)

Now ... which Column in which tab requires your CF ...?

 

[CyannideHigh]

Evo!$H:$H or "Secondary" if i don't need to re-name that too