Conditional Formatting – Access 2007 Form

Topic

New Reply

When attempting to use the conditional formatting button; I am limited to 3 different equal to options. I have several list items in the field and would like to group two or three items in the same conditional formatting. (i.e. Expired, Removed, Deleted all have Gray field with black text.)
I have attempted to use “Expired” Or “Removed and “Expired” And “Removed” but neither option works. Is there a way to use conditional formatting with AndOr statements?

Reply | Quote

Replies

You could use
Expression is [Text2]=”A” Or [Text2]=”B” Or [Text2]=”C”

Reply | Quote

That worked exactly as expected; thank you for helping me figure that out.

Reply | Quote