How do you include conditional formatting in a report?

Hi Stephen, welcome to the forum, Thanks for the post;
To change a field in a report based on its value, you can apply conditional formatting.
To do this, open your Access report and highlight the field that you want to change the behavior of.
In this example, lets consider using a field called Category ID field.
Under the Format menu, select Conditional Formatting.
When the Conditional Formatting window appears, enter the first condition. In our example, lets select when the field value is less than 3.
Next, you need to select what formatting to apply when the condition is met. Let’s consider choosing to change the color of the font to green and applying bold to the font.
If you wish to apply more than one condition, you will need to click on the Add button, say bold orange if equal or greater than 3, when finished click on the OK button.
Now, when you preview the report, the conditional formatting will be applied. In our example, the Category ID value is either bolded green when the value is less than 3, or bolded orange when the value is 3 or greater.
I hope that has helped, best regards Pete.