Using TEXTJOIN in a Conditional Formatting formula.

[Herakles]

I am trying to use TEXTJOIN in a Conditional Formatting formula and it doesn't like it.

What am I doing wrong?

See image.

=len(TEXTJOIN("",TRUE,$C3,$D3,$E3,$3,$G3,$H3))>10

Thanks

 

[SanjayGMusafir]

=len(TEXTJOIN("",TRUE,$C3,$D3,$E3,$3,$G3,$H3))>10

=len(TEXTJOIN("",TRUE,$C3,$D3,$E3,$3,$G3,$H3))>10

Probably the red highlighted above - It does not refer to any cell...

Try and revert -

=len(TEXTJOIN("",TRUE,$C3:$H3))>10

 

[Herakles]

=len(TEXTJOIN("",TRUE,$C3,$D3,$E3,$3,$G3,$H3))>10

Probably the red highlighted above - It does not refer to any cell...

Thanks SanjayGMusafir.

A good reason why one should always select the cells rather than write them in.

 

[Peter_SSs]

Since you are using TEXTJOIN with "" as the joiner, it would make more sense just to use CONCAT instead.

23 07 24.xlsm
	C	D	E	F	G	H
1
2
3	46	37	22	3	24	86
4	10	2	98	3	5	4
5	11	12	13	14	15	16
CF > 10

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:H5	Expression	=LEN(CONCAT($C3:$H3))>10	text	NO

 

[Herakles]

Since you are using TEXTJOIN with "" as the joiner, it would make more sense just to use CONCAT instead.

23 07 24.xlsm
	C	D	E	F	G	H
1
2
3	46	37	22	3	24	86
4	10	2	98	3	5	4
5	11	12	13	14	15	16
CF > 10

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C3:H5	Expression	=LEN(CONCAT($C3:$H3))>10	text	NO