C. F. Formulas Needed
On Tue, 9 Dec 2003 03:57:36 -0800, "Phil Hageman"
wrote:
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
I think the way you have written the specifications, checking for B30 to be
"not blank" is superfluous.
=OR(AND(B30M18,B30<M20),AND(B30M24,B30<M27))
does the rest.
Note that you specified "between". So if M18=2 and M20=5, neither 2 nor 5
would be "between".
That being the case, the testing of B30 for not being blank is unnecessary.
--ron
|