Conditional formating of two forms in Access 2010

[DevelopV]

I have two forms, frmSuggestedStock & frmActualStock

frmSuggestedStock is bound to tblStock
frmActualStock is bound to qryStockConsumed

I cannot have a single form using a query because the user needs to be able edit records in frmSuggestedStock.

Sample records in frmSuggestedStock include
ProductId,SuggestedStockLevel
1,10
2, 5
3, 9
4, 1

Sample records in frmActualStock include
ProductId, ActualStockLevel
1, 15
2, 3
3, 9

I would like to introduce conditional formatting to the forms to change the back color of fields SuggestedStockLevel & ActualStockLevel

For example
frmActualStock
back color of field ActualStockLevel for ProductId 1 should be green (excess stock)
back color of field ActualStockLevel for ProductId 2 should be red(short stock)
back color of field ActualStockLevel for ProductId 2 should be white(correct stock)

frmSuggestedStock
back color of field ActualStockLevel for ProductId 4 should be red(no stock)

Is this possible in Access 2010?

Thanks