Conditional Formatting Problem

I am using Access 2007.

I am trying to apply simple conditional formatting but it is not working.

Condition 1
If the Field Value
is equal to
"Completed"

then background should be "green"

Condition 2
If the Field Value
is equal to
"not Started"

then background should be "red"

Condition 3
If the Field Value
is equal to
"In Progress"

then background should be "yellow"

when I view the data the formats are not applied. Any ideas?

I'm having the exact same problem. Can someone please answer this question?

In my case and to clarify - the conditional formatting works on the form,
but when I open a report it does not (background stays white).

Thank you very much.

"Williams" wrote:

I am using Access 2007.

I am trying to apply simple conditional formatting but it is not working.

Condition 1
If the Field Value
is equal to
"Completed"

then background should be "green"

Condition 2
If the Field Value
is equal to
"not Started"

then background should be "red"

Condition 3
If the Field Value
is equal to
"In Progress"

then background should be "yellow"

when I view the data the formats are not applied. Any ideas?