Access has conditional formatting just like Excel. You select the label in yourform and then I believe under the edit dropdown is conditional formatting.