I have a situation on an Access form where I need to apply 2 different sets of conditional formatting on the same object and I could use some help.

I would like to use the "Conditional Formatting" feature as I have no VB experience and neither do the people who will be maintaining this database. Here is basically what I need.

Condition 1: If [date] is <=5/31/12 and [Avg MN] is >.993 (then format background to red)

-OR-

Condition 2: If [date] is >5/31/12 and [Avg MN] is >1.04 (then format background to red)

I know that you can use the "expression is" feature but I don't know how to word the expression.

Here's an example of what I tried putting in the box beside "expression is" on the conditional format window...but it didn't work.

=iif [date] is <= 5/31/12 and [avg mn] is > .993 (then I selected to format the background fill to red if the condition was true)

I added a second condition and entered the following in the box beside "expression is":

=iif [date] is >5/31/12 and [avg mn] is >1.04 (then I selected to format the background to fill to red if the condition was true)

Maybe someone will see the error of my ways here.

P.S. The data in square brackets is the actual field names (I know, I know...poor naming convention but I didn't do it)