Conditional Format

[avisoft20]

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

Example:

Date	Material Code
01/10/2019	2002025
01/10/2019	2002025
01/10/2019	2002115

<tbody>
</tbody>

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
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

<tbody>
</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
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

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</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