Conditional formatting

[Edwards28]

I have a set of data (5 colums wide 50+ rows down) containing both numbers and text.

I would like to highlight all numbers greater than 5 in red and all lower than 5 in green.

The issue I’m having is it’s highlighting all the cells containing text red, is there a way to ignore the text?

 

[JumboCactuar]

for your conditional formatting,
formulas:

red

=VALUE(E2)>=5

green

=VALUE(E2)<5

 

[jtakw]

Hi,

Book1
	A	B	C	D
1			for Green	for Red
2	4		TRUE	FALSE
3			FALSE	FALSE
4	7		FALSE	TRUE
5	five		FALSE	FALSE
6			FALSE	FALSE
Sheet175

Cell Formulas
Range	Formula
C2	=AND(ISNUMBER(A2),A2<5)
D2	=AND(ISNUMBER(A2),A2>5)

What happens when A2 = 5 ?, I've assumed no highlight.