3 columns - Highlight lowest value - But only if true lowest not a tie.

[moyerj26]

My columns look like this.

6 8 9

I want 6 to be highlighted using conditional formating.

That works great.

But if my column looks like this

6 6 8

It will highlight both 6's.

I need help with conditional formating formula so that it ONLY highlights when there is a TRUE Lowest value without a tie.
If there is a tie for lowest value I do not want them to highlight.

Thank you for your help.

 

[dreid1011]

Give this a try. Results in col J:

Book1
	A	B	C	D	E	F	G	H	I	J
1		6	7	8		1	1	1		6
2		6	6	8		2	2	1		8
3		1	1	1		3	3	3
4		9	8	5		1	1	1		5
5		2	5	5		1	2	2		2
Sheet2

Cell Formulas
Range	Formula
F1:H5	F1	=BYCOL(B1:D1,LAMBDA(c,COUNTIF(B1:D1,c)))
J1:J5	J1	=LET(r,B1:D1,IFERROR(MIN(FILTER(r,BYCOL(r,LAMBDA(c,COUNTIF(r,c)))=1)),""))
Dynamic array formulas.

 

[iggydarsa]

Assuming your three columns are A, B, and C and you have a header line on the first row so the data starts on the second row

Select A and start your conditional formatting
Select Use formula option and type in =AND(COUNTIF($A2:$C2, MIN($A2:$C2))=1, A2=MIN($A2:$C2))

Copy this cell and paste the formatting only on the three columns

 

[dreid1011]

Give this a try. Results in col J:

Book1
	A	B	C	D	E	F	G	H	I	J
1		6	7	8		1	1	1		6
2		6	6	8		2	2	1		8
3		1	1	1		3	3	3
4		9	8	5		1	1	1		5
5		2	5	5		1	2	2		2
Sheet2

Cell Formulas
Range	Formula
F1:H5	F1	=BYCOL(B1:D1,LAMBDA(c,COUNTIF(B1:D1,c)))
J1:J5	J1	=LET(r,B1:D1,IFERROR(MIN(FILTER(r,BYCOL(r,LAMBDA(c,COUNTIF(r,c)))=1)),""))
Dynamic array formulas.

Oops, sorry, I forgot you were looking for conditional formatting.

 

[iggydarsa]

Oops, sorry, I forgot you were looking for conditional formatting.

Also, the way understand, your row 2 should not return anything.

 

[dreid1011]

Also, the way understand, your row 2 should not return anything.

I can see that. I just went with next lowest value.