Conditional formatting a range which is dynamic

[Formula11]

How can I apply conditional formatting to a range which is dynamic.
The start cell is known.
The end row is the last non blank row, in the example below, 14.
The last column is the last non blank column, in this case, G.

 

[etaf]

i notice you do have blank rows
how about

=COUNTA($A1:$J10000)<>0

Change J10000 to the maxium number of cells ever likely to have text in

Book2
	A	B	C	D	E	F	G	H	I	J
1
2
3
4		text
5
6
7		text
8
9						text
10			tex
11				ff
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:J25	Expression	=COUNTA($A1:$J10000)<>0	text	YES

 

[Formula11]

Thanks, but above should stop at column F.

 

[etaf]

ok,
so change the selected range to A to F
and the formula
=COUNTA($A1:$F10000)<>0

Book2
	A	B	C	D	E	F	G	H	I	J
1
2
3
4		text
5
6
7		text
8
9						text
10			tex
11				ff
12
13
14
15
16
17
18
19
20		ttt
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:F100000	Expression	=COUNTA($A1:$F10000)<>0	text	YES

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A1:F10000 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=COUNTA($A1:$F10000)<>0

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[Formula11]

Thanks for letting me know, but the range is always changing, adding text, deleting text, adding rows/columns, deleting rows/columns.
The last row and column are 2 variables.

 

[etaf]

OK, so on your example column G has TEXT in , but you say it should only goto to F

Thanks, but above should stop at column F.

I suspect you may need VBA to actually dynamically set the range , that th ecionditional formatting is selecting to use - otherwise you may need to apply to a much bigger range - like A1:AZ100000 or larger

What version of Excel are you applying too

 

[Formula11]

I understand but I have mentioned it's dynamic, so in my example I pointed out G is the last column, in yours F is the last column.
OK I will look at using VBA then.
Thanks.