Andrew,
This could get complicated based upon the order that you want something to happen. If you flow chart it first, then it is easier to build the If Statements. However if your Bill of Materials is released this might solve your issue:
If ( [BOM Release Date]<>"", $green,
[Required BOM Release Date]<Today(),$red,
Today()-Days(10) < [BOM Yellow Date] ,$yellow, "")
If Operations has released the BOM you will be Green even if it was late. The last part might not be acceptable for your business logic.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
