Hey guys,

so Ive got Product Form, which has SubForm Linked Samples. 

In SubForm Linked Samples, there is a Lookup field to a separate Form "Sample Intake"

The other parts of the subform are Factory and Status. 

based on what is selected in Status, i want the Report to formatted with highlighting, for each subform record entered. 

so like this

Thoughts?