Conditional Formatting formula

T

tankerman

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.
 
D

Dave F

Try removing the quotes aroung the 123.

123 is presumably formatted as a number, not text.

Dave
 
Top