A simple example (using a subform and viewing the datasheet) of utilizing the conditional formatting to set colors.

View the Conditional Formatting settings in the design view on the subform of the ID and RecID fields.