C. F. Formulas Needed
Between means inclusive:
=AND(B30<"",OR(AND(B30=M18,B30=<M20),AND(B30=M2 4,B30=<M27)))
or not inclusive:
=AND(B30<"",OR(AND(B30M18,B30<M20),AND(B30M24,B 30<M27)))
2nd:
=And(B30<"".OR(B30=M18,B30<=M24))
--
Regards,
Tom Ogilvy
"Phil Hageman" wrote in message
...
I need two conditional formatting formulas with the
following criteria:
The first formula:
B30 is not blank
And
B30 is between M18 and M20, or, between M24 and M27
The second formula:
B30 is not blank
And
B30 is greater than or equal to M18, or, less than or
equal to M24
Thanks, Phil
|