Conditional Formatting a Table in Access 2013

[drd144]

I have a table in access and I need to format it so that when column "Status" = "Closed" column "Closed" = "yes". so it will automatically mark column "Closed" "yes" if "status" says "closed". Instead of having to change both columns all the time.

I know how to do that in MS Excel, but is it possible in MS Access 2013?

[June7]

Why do you have both columns? Seems redundant to me.

[orange]

Access(database) is quite different than Excel(spreadsheet). I agree with June7 that your fields seem to be redundant. Typically in relational database 1 field represents 1 fact/thought/concept.
You may wish to research relational database design and/or Normalization.

Good luck with your project.

[drd144]

Why do you have both columns? Seems redundant to me.

I guess really I don't. I'm working for someone else and they won't let me edit the database.... I didn't even think of that though.... thanks for you help.