Conditional formatting on cell for lines over 65 Characters (each separated by line break)

[EAG1]

Hello all,

I have the following in a single cell and want to highlight it red if any of the lines are over 65 Characters. The lines are separated by alt enter (line break).

This is a test!
This is another test!
This is a further test which happens to be over 65 characters in length!

Ideally, I need a formula to put into the conditional formatting section.

Any help would be much appreciated.

Thanks, EAG1

 

[Peter_SSs]

Do you have the TEXTSPLIT function?

23 03 09.xlsm
	A
1	Text
2	This is a test! This is another test! This is a further test which happens to be over 65 characters in length!
3	This is a test! This is another test! This is a further test
4	This is a test! This is another test! This is a further test which happens to be over 65 characters in length!
>65 characters

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A4	Expression	=MAX(LEN(TEXTSPLIT(A2,CHAR(10))))>65	text	NO

 

[EAG1]

@Peter_SSs Yes I do and had been playing around with it but couldn't get it to work. Your formula works a treat. Thank you very much for the help.

 

[Peter_SSs]

Good news all around then.
Thanks for the follow-up.