How do i use Conditional formatting for 3+ conditions ?

R

Roger

I have a text box in a report which highlights in colour current members in
a list of past and present member names. I have six types of current members
that I want to highlight, but with conditional formatting I can only use 3
conditions in the members [Type] field. I have tried [Type]="Full member" Or
"Life member" but the "Or" doesn't work ! Is there a way to do this ?

thanks .. Roger
 
A

Allen Browne

CF is limited to 3 contitions, but you can use OR in those expressions.

If you set Condition1 to Expression, you can use:
([Type] = "Full member") Or ([Type] = "Life member")

If that still doesn't work, open the table in design view, and see what kind
of field Type is. If it is a Number (using a combo to show the text), you
will need to put the correct numbers here instead of the text. And the
numbers don't go in quotes.

If you do end up needing more than 3 colors, and you are comfortable with
VBA code, you can set the BackColor of the text box in the Format event of
its section.
 
J

Jane

You need to include the field name each time.
if [Type]="Full member" Or [Type]="Partial Member" or [Type]="New Member"....
then
(Whatever you want to happen)
end if
 
Top