Conditional format and comparing dates

[Hank]

How do I do this on a report?
If the difference between date1 and date2 is greater than 42 days then date
1 should be bold, else nothing. date1 is the control cell in which I'm
trying to enter the formula but I'm coming up with nothing.

 

[Marshall Barton]

How do I do this on a report?
If the difference between date1 and date2 is greater than 42 days then date
1 should be bold, else nothing. date1 is the control cell in which I'm
trying to enter the formula but I'm coming up with nothing.

Try using the Expression Is" option with something like:

DateDiff("d", [date1], [date2]) > 42

Note that the [ ] are required.

You didn't say which date is the earlier date so you might
have to switch the 1 and 2.