=len(TEXTJOIN("",TRUE,$C3,$D3,$E3,$3,$G3,$H3))>10=len(TEXTJOIN("",TRUE,$C3,$D3,$E3,$3,$G3,$H3))>10
=len(TEXTJOIN("",TRUE,$C3:$H3))>10
Thanks SanjayGMusafir.=len(TEXTJOIN("",TRUE,$C3,$D3,$E3,$3,$G3,$H3))>10
Probably the red highlighted above - It does not refer to any cell...
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 |
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