Conditional Formatting : Numbers & Texts Conflict

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 I put a text (e.g : N), it'll change to blue pattern also?

Kindly help me to solve this confussion .
Thanks

>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" <[email protected]> wrote in
message news:[email protected]...
>
> 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 I
> put a text (e.g : N), it'll change to blue pattern also?
>
> Kindly help me to solve this confussion .
> Thanks
>
>
> --
> nayinky
> ------------------------------------------------------------------------
> nayinky's Profile:
> http://www.excelforum.com/member.php...o&userid=37215
> View this thread: http://www.excelforum.com/showthread...hreadid=569307
>

Thanks for your help. Done for now

You're welcome!

Biff

"nayinky" <[email protected]> wrote in
message news:[email protected]...
>
> Thanks for your help. Done for now
>
>
> --
> nayinky
> ------------------------------------------------------------------------
> nayinky's Profile:
> http://www.excelforum.com/member.php...o&userid=37215
> View this thread: http://www.excelforum.com/showthread...hreadid=569307
>