Look at conditional formatting. In Design view, select the items in the Detail section of the report to be highlighted, and go to the "Format" dropdown menu and then to "Conditional Formating...". This will let you set up the desired format under the desired set of conditions.