Conditional formatting date control based on null

[matey56]

Hi,


I have two controls in a form I'd like to base my conditional formatting on. Both are date fields. The first one will turn red if the date is past 42 days. I got that part. I just used Now()+42. But what I need to do next is remove the conditional formatting if the second field is NOT NULL....so once someone enters text into the second field the first date field will not be red. How do I do that?

[June7]

Should probably use Date() instead of Now().

If you want highlight when date field is > Date() +42 AND second field is null, try:

Expression is: [date field] > Date() + 42 AND IsNull([other field])

[matey56]

Should probably use Date() instead of Now().

If you want highlight when date field is > Date() +42 AND second field is null, try:

Expression is: [date field] > Date() + 42 AND IsNull([other field])

Thanks, that works great! Another question - how do I write the expression if the date is between 27 and 41 days?

[June7]

[date field] BETWEEN Date() + 27 AND Date() + 41 AND IsNull([other field])

[matey56]

It's working. Thanks so much for your help.