Conditional Formatting with expressions 2

[houstonbill]

Have checked multiple postings but cannot seem to get the result I need. Looking for some help with my expressions for conditional formatting. Have a bound text box (AvgASA) with a result for each of 12 months {ToDate]. Based on the date range, the target value for the AvgASA will change. I need to show those months where the target was not met with a background of Red. Here is what I have on my Conditional Formatting form, designated as an expression:

[AvgASA]>120 And[ToDate]Between 01/01/2006 And 02/28/2006
[AvgASA]>100 And[ToDate]Between 03/01/2006 And 05/31/2006
[AvgASA]>80 And[ToDate]Between 06/01/2006 And 12/31/2006

 

[PHV]

Perhaps this ?
[AvgASA]>120 And [ToDate] Between #2006-01-01# And #2006-02-28#

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[houstonbill]

That did it! This is the first time I have used conditional formatting and I was soooo close. Thanks much.