change color in one record without changing others

[eecalta]

I've set up a database for a scheduling program in a manufacturing
environment that pulls all the information I need into reports for front
office, however I would like to "color code" certain records in a report
based on the status of the work in progress without affecting other records
that the criteria doesn't apply to. Is this possible?

 

[Marshall Barton]

I've set up a database for a scheduling program in a manufacturing
environment that pulls all the information I need into reports for front
office, however I would like to "color code" certain records in a report
based on the status of the work in progress without affecting other records
that the criteria doesn't apply to. Is this possible?

Sure. Check the Conditional Formatting item on the Format
menu (when the report is open in design view).

If that's not sufficient for whatever your specific needs
are, then VBA code can be used to do all kinds of things.