|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cell C2 value: |
3 |
|
|
Cell H2 date: |
|
1/1/2011 |
|
|
|
|
|
|
Cell C3 value: |
5 |
|
|
Cell H3 date: |
|
2/1/2011 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Whole Numbers |
|
|
|
Dates |
|
|
|
|
|
|
|
|
input between 10 and 20 |
|
|
|
date between 1/1/2011 and 2/1/2011 |
|
|
|
|
|
|
|
|
input not between 10 and 20 |
|
|
|
date not between 1/1/2011 and 2/1/2011 |
|
|
|
|
|
|
|
|
input = 10 |
|
|
|
date = 1/1/2011 |
|
|
|
|
|
|
|
|
input <> 10 |
|
|
|
date <> 1/1/2011 |
|
|
|
|
|
|
|
|
input > 10 |
|
|
|
date > 1/1/2011 |
|
|
|
|
|
|
|
|
input < 20 |
|
|
|
date >= 1/1/2011 |
|
|
|
|
|
|
|
|
input >= 10 |
|
|
|
date < 2/1/2011 |
|
|
|
|
|
|
|
|
input <= 20 |
|
|
|
date <= 2/1/2011 |
|
|
|
|
|
|
|
|
input between C2 and C3 |
|
|
|
date between H2 and H3 |
|
|
|
|
|
|
|
|
input not between C2 and C3 |
|
|
|
date not between H2 and H3 |
|
|
|
|
|
|
|
|
input = C2 |
|
|
|
date = H2 |
|
|
|
|
|
|
|
|
input <> C2 |
|
|
|
date <> H2 |
|
|
|
|
|
|
|
|
input > C2 |
|
|
|
date > H2 |
|
|
|
|
|
|
|
|
input < C3 |
|
|
|
date >= H2 |
|
|
|
|
|
|
|
|
input >= C2 |
|
|
|
date < H3 |
|
|
|
|
|
|
|
|
input <= C3 |
|
|
|
date <= H3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Text Length |
|
|
|
Lists |
|
|
|
|
|
|
|
|
text length between 3 and 5 |
|
|
|
apple, banana, pear |
|
|
|
|
|
|
|
|
text length not between 3 and 5 |
|
|
|
with spaces |
|
|
|
|
|
|
|
|
text length = 3 |
|
|
|
from cell range |
|
|
|
|
option1 |
option2 |
option3 |
|
text length <> 3 |
|
|
|
|
|
|
|
|
|
|
|
|
text length > 3 |
|
|
|
input title only |
|
|
|
|
|
|
|
|
text length < 5 |
|
|
|
input message only |
|
|
|
|
|
|
|
|
text length >= 3 |
|
|
|
input title and message |
|
|
|
|
|
|
|
|
text length <= 5 |
|
|
|
|
|
|
|
|
|
|
|
|
text length between C2 and C3 |
|
|
|
|
|
|
|
|
|
|
|
|
text length not between C2 and C3 |
|
|
|
|
|
|
|
|
|
|
|
|
text length = C2 |
|
|
|
|
|
|
|
|
|
|
|
|
text length <> C2 |
|
|
|
|
|
|
|
|
|
|
|
|
text length > C2 |
|
|
|
|
|
|
|
|
|
|
|
|
text length < C3 |
|
|
|
|
|
|
|
|
|
|
|
|
text length >= C2 |
|
|
|
|
|
|
|
|
|
|
|
|
text length <= C3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Numbers |
|
|
|
|
|
|
|
|
|
|
|
|
decimal between 3.0 and 5.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|