Highlighting dates if they come within 7 days of todays date.

[Jcat8175]

I have a report that shows a list of quotes my company has done with a
certain time frame, it removes all lost/won contracts and shows the most
recent 'status' of the project eg "on hold call back in a month"

I then have a field where the date is input for the follow up call called
"Call Due On"

Is it possible to highlight in red or something any dates in this field that
appear within a week either side of the date the report is printed on?

If its not possible, is there a way to automatically print another report
when printing this one eg 'Follow ups ' that i can just set up a parameter
search pop up on it?

 

[Jcat8175]

Never mind I've sorted it- I'm officially stupid - why I didnt think of
conditional formatting to begin with is beyond me!