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?
>
>