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