Condition of a condition formatting

[7ftbill]

Hey guys, new to the forums.
I have comparisons that I need to do, that I've been going through manually for thousands of lines of data - I need to speed this process up.

My format is this:
STORE / SKU / QTY

Each store will have multiple entries for all of their stock, with MULTIPLE entries of SKUs and QTY's, example (ALL stores are on the same sheet):
STORE A / 123 / 5
STORE A / 123 / -3
STORE A / 125 / 3
STORE A /125 / -3
etc...
There are roughly 60 stores that might have a positive and negative (of the same sku) QTY based off different days of inventory counts - the day of the count does not matter to me as stores find and miss counts of stock all the time.
BUT, I need a way of seeing a MATCH of QTY, SKU, and STORE easily AND/OR a NON match of QTY, SKU, and STORE.

In my head I was thinking a conditional formatting option to at least highlight the match of SKU per STORE and then I can manually look to see if the values are the same or different, but if I can add a third option onto that to see if the values match or are different then that would be the cat's meow.


Thanks in advance for any assistance!

 

[etaf]

a countifs() should work

Book1
	A	B	C
1	STORE A	123	5
2	STORE A	123	-3
3	STORE A	125	3
4	STORE A	125	-3
5	STORE A	123	5
6	STORE A	125	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:C	Expression	=COUNTIFS($A:$A,$A1,$B:$B,$B1,$C:$C,$C1)>1	text	NO

 

[7ftbill]

a countifs() should work

Book1
	A	B	C
1	STORE A	123	5
2	STORE A	123	-3
3	STORE A	125	3
4	STORE A	125	-3
5	STORE A	123	5
6	STORE A	125	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:C	Expression	=COUNTIFS($A:$A,$A1,$B:$B,$B1,$C:$C,$C1)>1	text	NO

Thanks etaf for the reply. I think this may not work in my situation, as I need to see both rows highlighted of the matched sku.
I will restate my needs in a different way:
* I would love to see the following outcome - PER STORE > Matched SKU "highlighted" (easiest option)
* Even better would be this: PER STORE > Matched SKU > Matched QTY (meaning 3 positive and -3 negative is a "match") "highlighted in green" > Miss matched (meaning still positive or negative left over) QTY "highlighted in yellow"

I will give you a more robust example of my data:

STORE	SKU	Quantity
Store 1	610214666376	-1​
Store 1	610214666376	-1​
Store 1	610214666420	3​
Store 1	610214666420	-1​
Store 1	610214666505	2​
Store 1	610214666505	-2​
Store 2	660543432319	3​
Store 2	660543432319	-3​
Store 2	660543511304	4​
Store 2	660543511373	-3​
Store 2	660543515081	3​
Store 2	660543515081	-3​
Store 2	660543515081	1​
Store 2	660543515081	-1​
Store 3	660543516675	1​
Store 3	660543516675	-1​
Store 3	660543517320	9​
Store 3	660543517320	-10​
Store 3	660543527220	1​
Store 3	715802842764	1​
Store 3	715802842764	-1​
Store 3	715802843075	1​
Store 3	715802843563	1​

 

[7ftbill]

Anyone have another input on this?