Highlight Numerical >0 without highlighting text - Conditional Formating

[iansitorus]

Hi I want to highlight multiple cells of text and numerical values with conditional formatting

This is the prompt,
PROMPT: "Highlight only cells that contain numerical value >0"

Logically it will be solved with the "greater than" option then, cell value >0
However the cells sometimes have text on their value, and these cells also get highlighted by the formula

Could anyone help me to solve the formula?

 

[DanteAmor]

Hi @iansitorus
Welcome to the MrExcel forum. Please accept my warmest greetings and sincere hope that all is well.

Use this formula:

Dante Amor
	G	H	I	J	K	L	M	N	O	P
1
2	0
3	1
4	-2
5	3
6	dc
7	2
Hoja2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G:I,L:P	Expression	=AND(ISNUMBER(G1),G1>0)	text	NO

--------------
Let me know the result and I'll get back to you as soon as I can.
Cordially
Dante Amor
--------------​

 

[Peter_SSs]

Welcome to the MrExcel board!

Another possible option

23 06 03.xlsm
	G
1	3
2	0
3	5x
4	-4
5	236598
6
7	apple
8	0.01
9	-0.01
10	22
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G1:G10	Expression	=--G1>0	text	NO

 

[iansitorus]

Hi @DanteAmor and @Peter_SSs thank you very much for solving my problem.
I really appreciate your warm welcome to the MrExcel forum!

 

[Peter_SSs]

You're welcome. Glad the forum was able to help. Thanks for the follow-up.