Select the range that you want formatting, then select
Format/conditional formating, select Formula Is then
enter:

=AND($B$30<"",OR(AND($B$30$M$18,$B$30<$M$20),AND
($B$30$M$24,$B$30<$M$27)))

As thsi is a code grouP:

Sub SetCF()

With Range("C7:G15")
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, _
Formula1:= "=AND($B$30<"""", _
OR(AND($B$30$M$18,$B$30<$M$20), _
AND($B$30$M$24,$B$30<$M$27)))"
.FormatConditions(1).Interior.ColorIndex = 34
End With
End Sub



Patrick Molloy
Microsoft Excel MVP

-----Original 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
.