CF help.

[serge]

Hi everyone,

I'm looking for a CF formula that will highlight duplicate per row and if it is possible to have 2 color to differentiate 2 different duplicate if not one color.See table.
Thank you.

 

[Fluff]

For one colour how about.

+Fluff New.xlsm
	A	B	C	D	E	F
1
2	25	27	24	27	24
3	20	27	27	25	23
4	23	28	23	22	21
5	28	21	30	29	27
6	27	30	27	23	24
7	25	25	20	30	23
8	29	29	24	20	29
9	21	22	24	30	21
10	27	21	25	30	30
11	27	22	25	25	27
12
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E11	Expression	=COUNTIFS($A2:$E2,A2)>1	text	NO

 

[serge]

Thank you Fluff, it works perfect, to bad I can't get 2 colors, I appreciate your help.
Serge.

 

[Fluff]

Pretty sure I've seen it done with two colours, but can't remember how.

 

[Fluff]

Got it.

+Fluff New.xlsm
	A	B	C	D	E
1
2	25	27	24	27	24
3	20	27	27	25	23
4	23	28	23	22	21
5	28	21	30	29	27
6	27	30	27	23	24
7	25	25	20	30	23
8	29	29	24	20	29
9	21	22	24	30	21
10	27	21	25	30	30
11	27	22	25	25	27
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:E11	Expression	=AND(MODE($A2:$E2)<>A2,COUNTIFS($A2:$E2,A2)>1)	text	NO
A2:E11	Expression	=COUNTIFS($A2:$E2,A2)>1	text	NO

 

[serge]

You are a Genius Thank you so much.
Serge.

 

[Fluff]

You're welcome & thanks for the feedback.