Conditional Formatting formula
 

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.

Conditional Formatting formula
 

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.

Conditional Formatting formula
 

Perfect, works great

Thanks

"Dave F" wrote:

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.