Color (CF) last adjacent cell if it contains random text

[K0st4din]

Hello, everyone,
I am asking for a little help, is it possible with Conditional formatting to make the last cell containing text be colored red or some other color. I found examples, but there they are given if I search for a specific word. For example, I'm looking for House and if the word is there it can be colored, but in my example, things are dynamic and I only need it if there is random text OR the last occupied adjacent cell in the example E12 and F12 be colored.
Thank you in advance.

fasf	gfgf	hgh	jhjh	kjkjk	page
fjafasf fasjfa	54	kar	london	fafafaf	1
fjafasf fasjfa	54	kar	london	ghfgfjf	2
fjafasf fasjfa	54	kar	london	dfsd	3
fjafasf fasjfa	54	kar	london	vvbxbxbx	4
fjafasf fasjfa	54	kar	london	hgfjhj	5
fjafasf fasjfa	54	kar	london	fxvvx	6
fjafasf fasjfa	54	kar	london	nbfgd	7
fjafasf fasjfa	54	kar	london	xbfgr	8
fjafasf fasjfa	54	kar	london	ghtyt	9
fjafasf fasjfa	54	kar	london	fhtjyu	10
fjafasf fasjfa	54	kar	london	sdfereretr	11
	0				12
	0				13
	0				14
	0				15
	0				16

 

[Peter_SSs]

Does this CF do what you want?

23 11 27.xlsm
	E	F
1	kjkjk	page
2	fafafaf	1
3	ghfgfjf	2
4	dfsd	3
5	vvbxbxbx	4
6	hgfjhj	5
7	fxvvx	6
8	nbfgd	7
9	xbfgr	8
10	ghtyt	9
11	fhtjyu	10
12	sdfereretr	11
13		12
14		13
15		14
16		15
17		16
CF Last

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F2:F17	Expression	=AND(E2<>"",COUNTA(E2:E$1000)=1)	text	NO

 

[K0st4din]

Hello, it works, but I didn't foresee that in column E I have formulas that take the text from another worksheet and I think from there with your formula it colors me, but the last cell, apparently reads the formulas. I didn't foresee that, or I'm wrong somewhere.

It should color cell F3, but either I'm mistaken or because of the formulas it "reads" wrong

 

[Peter_SSs]

in column E I have formulas

That's one reason 'Mini Sheet' is generally better to use than 'Table Only' with XL2BB.

Change the CF formula to

=AND(E2<>"",COUNTIF(E2:E$1000,"?*")=1)

 

[K0st4din]

Thank you very much, now it is doing it right.
Thank you very much for the quick response.
Be alive and well.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.