Open your form in Design View. Click on the field you want to have change color. Click on Format/Conditional Formatting. You can set up to 3 Conditions... which seems to meet your requirement.
[quote]For instance, the fieldname is 'Status'. I want the color to be red if the status is 'In Progress', blue if 'Complete' and green if 'Unknown'. [end quote]
