Help with Conditional Formatting Please.

[serge]

I need to highlight numbers with different color when there is duplicate.

Row 3 : 1-3-7 All different digits so they will be in green.
Row 4 : 4-5-4 Duplicate of 4 so they will be in blue and 5 stay in green.
Row 5 : 8-8-8 Duplicate of 8 so they will be in red.

Thank you in advance.
Serge.

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1					1	2	3
2
3	1	3	7		1	2	3	4	5	6	7	8	9
4	4	5	4		1	2	3	4	5	6	7	8	9
5	8	8	8		1	2	3	4	5	6	7	8	9
6
Sheet1

 

[Ruddles]

Set your conditional formatting for cell E3 using this formula:-

=COUNTIF($A3:$C3,E3)=1

with fill colour green. Use this formula:-

=COUNTIF($A3:$C3,E3)=2

with fill colour blue. Finally use this formula:-

=COUNTIF($A3:$C3,E3)=3

with fill colour red.

Test they work by altering the number of 1's in A3:C3, then copy the format only to E3:M5.

 

[serge]

Hi Ruddles,

Your formulas work fine, thank you very much for the help.

Regards.
Serge.

 

[Ruddles]

Thanks for the feedback.