Is it possible to change the color of some records in a table in MS Access based on specific conditions?

Users should never see, much less care about how a table's datasheet looks.  Users, including yourself, should ALWAYS use a form to view/edit data (or a report if you need to print or present a more complex layout than can easily be done in a form.  In other words, tables and queries are NOT a user interface mechanism and consequently what few formatting features do have are still too many.

If you create a simple continuous or datasheet form based on the table, then you can do what you want using the techniques I posted before.

Easy or not, that's how it's done in an Access continuous form.  Don't forget that Access is in no way a  spreadsheet on steroids.  It has to deal with many, many more things than any spreadsheet ever had to be concerned with.  And Datasheet forms are useful in some situations, but are very limited compared to what can be done with a continuous form.

If you insist on using a datasheet form, then the best you can do (just might be sufficient for your needs) is to use Conditional Formatting on every text box with the same Expression Is: settings.

This is something we can do easily in excel. Trying to get this as the result on clicking update button. IF the Status is C the record in the table should get a red color.

Hi,

no in the table , yes on a continuos form or on a report whit conditional formatting (right mouse button on a form's control).

Bye Mimmo

Hard to say without more information. Generally we would use Conditional Formatting but in your case there may not be a suitable expression to use.