Need more than four colors in a report

[Guest]

Greetings!
I am working with Access 2000, and a database written by a previous
designer. I have a report that is currently exported to Excel, then manually
highlighted in one of four colors (Red= paste due, Green = due this month,
Yellow = due 2 months and Blue = due in three) Conditional formating left me
one color short! This formating has to happen to about ten columns. I am not
very proficient with code or writing expressions, but I am a very fast
learner. Any help is appreciated. Than ks!

 

[Duane Hookom]

Are you expecting conditionally formatted controls to display conditionally
formatted in your Excel file? My experience suggests this won't happen.

 

[Guest]

Are you expecting conditionally formatted controls to display conditionally
formatted in your Excel file? My experience suggests this won't happen.

_____________________________________
Actually, I never want to have to export again. It is silly to go from one
to the other for this application. The only reason it did was because the
previous designer didn't know how to use conditional formating at all. The
report is a projection of future expiration dates and needs to be tracked 3
months ahead.
I think that a case type situation would work, but I am a little uncertain
how to build it, save it, then apply it.

 

[Duane Hookom]

You can write code in the On Format event of the section containing the
controls like:
Select Case DateDiff("d", Me.txtSomeDate, Date)
Case Is > 90
Me.txtSomeDate.ForeColor = vbRed
Case Is >60
Me.txtSomeDate.ForeColor = vbBlue
'... other code...
Case Else
Me.txtSomeDate.ForeColor = vbBlack
End Select