View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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