Conditional formatting

[SVE]

I have a report that has 4 fields-let's call them A-4D for ease of use. If
any two of the fields B-D meet a particular value (which CF turns the data
red in these fields when they meet this value), then the data in field 1
needs to turn bold and red.

Can anyone help me to make this happen?

Thank you in advance for any and all advice.

 

[Duane Hookom]

Please give us four field names, some sample data, and which ones should have
which fields/controls formatted.

 

[John Spencer]

Perhaps something like the following where "X" is the value you are testing
for.

Expression is Abs( = "x" + [C]="x" + [D]="x") >1

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..