I have a MS Access Report with about 50 records. I need the color of each record to change depending on the value of the value of one field. For example, if the status is ongoing, then the entire line (record) needs to be green. If the status is completed, the entire record needs to be displayed in blue. I would appreciate anyone that can help me with this.