Change report colour depending upon date

[sxs9999]

Hi, Hope help is available

I have a report that lists projects that are being carried out by users,

What I need to know is how can I set a traffic light system up on the report to show Green 10days+ before due date amber5 to 10days before due date and red after due date... bearing in mind that I can have 100's of projects that are on the report at different stages of progress and each will need there own set of colour depending on date


Please can anyone help?

 

[Norie]

There is AutoFormat in Access 2000

 

[sxs9999]

Thanks Norie

but I think You have mis understood what I'm after.

I grab the report and repost to let you see what I mean

SXS

 

[Norie]

I meant Conditional Formatting sorry.