Character count on each line within one cell

[ramesanscesse]

Hi everyone!

I am desperately trying to find the right formula (can't be a macro or anything complicated like that) to count the amount of characters on each line within a cell.
I have been trying to find it for years, it's driving me nuts, so at long last, I worked up the courage to create an account and ask here, in hopes that you guys can help me put this matter to rest once and for all
Ideally, it's something that would display like this, in B2, once applied (and that could be dragged down to do the same for each additional text cell in the A column).

I used to have a supervisor at an old job who knew this formula, some 7 or 8 years ago, but I've changed companies since, and no one at my new company seems to know it even the higher-ups who are really good at Excel. And even my co-workers from my old company can't remember it either, we just know it was fairly lengthy. As you can imagine, I've tried googling it many times over the years, but since English isn't my first language and I am pretty much technologically illiterate (I'm joking ofc... but barely!), I haven't been able to find it, so I really hope I'll be able to get an answer here.
Many thanks in advance!

P.S.: if you're using technical terms, please explain them to me like you would to someone from the Middle Ages
I'm very much a "Letters Over Computers"-type of person, haha!

 

[Peter_SSs]

AFAIK Its not possible for conditional formatting to format part of a cell

The way I read col H in the image, that is not being asked for.

Also note that in the image some cells in col C have multiple values.

@ramesanscesse
In relation to my last sentence above, where a cell in column C has multiple values. In your image those cells have the same number (7) on each line within the cell. Is that always the case or could they be different like rows 8 & 9 in my example below?
Also, could the number of values in column C be different to the number of lines in column F (& column G)?

Anyway, this is my suggestion for the layout given

ramesanscesse.xlsm
	C	D	E	F	G
1
2	10			Mana Potion	11
3	10			HP Potion	9
4	10
5	10			Shield	6
6	7 7			Evil begone	4 6
7	7 7			verybiglongtextononeline short	24 5
8	3 5			two three	3 5
9	3 5			four three	4 5
Sheet1

Cell Formulas
Range	Formula
G2:G9	G2	=IF(F2="","",TEXTJOIN(CHAR(10),,LEN(TEXTSPLIT(F2,CHAR(10)))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:G9	Expression	=MAX(TEXTSPLIT(G2,CHAR(10))-TEXTSPLIT(C2,CHAR(10)))>0	text	NO

 

[Cubist]

You can try this.

Book2
	A	B	C
1	Text	Max Allowed	Text Count
2	Hello! Hi I hope you have a nice day, today.	7 3 50	6 2 34
3	Today is a beautiful day	1 8 1 2	5 2 1 13
Sheet3

Cell Formulas
Range	Formula
C2:C3	C2	=TEXTJOIN(CHAR(10),,LEN(TEXTSPLIT(A2,CHAR(10))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2:C3	Expression	=SUM(--(LEN(TEXTSPLIT(A2,CHAR(10)))>--TEXTSPLIT(B2,CHAR(10))))>0	text	NO

 

[MARK858]

The way I read col H in the image, that is not being asked for.

If it is not then there already a few posts (including my last 2) where the entire cell is highlighted

 

[Peter_SSs]

If it is not then there already a few posts (including my last 2) where the entire cell is highlighted

I didn't understand how the data in post #18 relates to the data/layout in the post #19 image but the post #20 CF does not work for me with the post #19 layout (G6 is not highlighted like in the image provided). Did I not apply it correctly?

ramesanscesse.xlsm
	C	D	E	F	G
1
2	10			Mana Potion	11
3	10			HP Potion	9
4	10			Shield	6
5	7 7			Evil begone	4 6
6	7 7			verybiglongtextononeline short	24 5
Sheet2

Cell Formulas
Range	Formula
G2:G6	G2	=IF(F2="","",TEXTJOIN(CHAR(10),,LEN(TEXTSPLIT(F2,CHAR(10)))))

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:G6	Expression	=SUM(--(LEN(TEXTSPLIT(F2,CHAR(10)))>C2))	text	NO

 

[MARK858]

Did I not apply it correctly?

No I think I misunderstood post 19