Conditional Format

[avisoft20]

Dear All Expert,
I am working on a data i need conditional format formula.

Example:
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]Date[/TD]
[TD]Material Code[/TD]
[/TR]
[TR]
[TD]01/10/2019[/TD]
[TD]2002025[/TD]
[/TR]
[TR]
[TD]01/10/2019[/TD]
[TD]2002025[/TD]
[/TR]
[TR]
[TD]01/10/2019[/TD]
[TD]2002115[/TD]
[/TR]
</tbody>[/TABLE]








Condition:if material code is same on same date it will be highlighted.

Thanx & Regards.
Avisoft

 

[MARK858]

Maybe with the data below (sorry it is not showing the colours)...
Select A2:A9 and apply the Conditional format formula

=COUNTIFS($A$2:$A$9,$A2, $B$2:$B$9,$B2)>1

Book1
	A	B
1	Date	Material Code
2	01/10/2019	2002025
3	01/10/2019	2002026
4	02/10/2019	2002115
5	01/10/2019	2002115
6	01/10/2019	2002025
7	01/10/2019	2002115
8	01/10/2019	2002027
9	01/10/2019	2002026
Invoice

 

[avisoft20]

Thanks Mark858.
But we required coloured when found duplicate material code on same date

	A	B
Date	Material Code

<tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002025[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002026[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]02/10/2019[/TD]
[TD="align: right"]2002115[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002115[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002025[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002115[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002027[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002026[/TD]

</tbody>

Invoice​

[/QUOTE]

 

[avisoft20]

Thanks Mark858.
But we required coloured when found duplicate material code on same date

Maybe with the data below (sorry it is not showing the colours)...
Select A2:A9 and apply the Conditional format formula

	A	B
Date	Material Code

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002025[/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002026[/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]02/10/2019[/TD]
[TD="align: right"]2002115[/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002115[/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002025[/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002115[/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002027[/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]01/10/2019[/TD]
[TD="align: right"]2002026[/TD]

</tbody>

Invoice​

 

[MARK858]

That is what the formula does... see the file in the link below!

Maybe with the data below (sorry it is not showing the colours).

https://app.box.com/s/v3pu4o7ecc2agwsnsno4y91xtt5glpqv