Conditional Formatting : Numbers & Texts Conflict

[nayinky]

Hi

I have put 2 conditional formats in a range of cells (A1:C5), i.e:

Condition 1: Cell Value Is greater than 10, blue pattern.
Condition 2: Cell Value Is less than 50, red font colour.

When i put number 5, it changed to red; 30 blue pattern. But why if
put a text (e.g : N), it'll change to blue pattern also?

Kindly help me to solve this confussion .
Thank

 

[Biff]

When i put number 5, it changed to red; 30 blue pattern. But why if I

put a text (e.g : N), it'll change to blue pattern also?

Because TEXT evaluates to be greater than ANY numeric value. Why is it like
that? I don't know, ask the programmers why they did that!

What you can do is use the Formula Is option and use something like this:

=AND(ISNUMBER(A1),A1>10)

Biff

 

[nayinky]

Thanks for your help. Done for now ;

 

[Biff]

You're welcome!

Biff