Try removing the quotes aroung the 123.

123 is presumably formatted as a number, not text.

Dave
--
Brevity is the soul of wit.


"tankerman" wrote:

When I put =OR($A$1="123") my condition will not work I am having to put a
letter with it to work, if I put "123P" in the conditional format
=OR($A$1="123") it works fine. What am I doing wrong, numbers and alphabet
mix works fine and alphabet alone works fine but not numbers.