Apply Conditonal Formatting to Form

Go to Design or Layout View, click on the column/field,  a "Form Design Tool" section appears on the top menu bar, go to format ==> Conditional Formatting

example rules: ([Status]="Backlog" Or [Status]="Completed") And [Active]="Yes"