L
Lee Hunter
I just discovered the answer to a problem and thought that I would share it
with the group.
How do I create a conditional format such that:
a cell must be between 1 and 100 or greater than 1000?
Answer: =OR(AND(A1>0,A1<101),A1>1000)
I hope this helps some else.
Lee
with the group.
How do I create a conditional format such that:
a cell must be between 1 and 100 or greater than 1000?
Answer: =OR(AND(A1>0,A1<101),A1>1000)
I hope this helps some else.
Lee