Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Please give us four field names, some sample data, and which ones should have
which fields/controls formatted.
 
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
..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Problem 1
Fields that don't satisfy criteria 1
Conditional Formatting in a Report 3
Conditional Formatting with a Date Function 1
Conditional Formatting 1
Conditional formatting based on Table 2
Another Conditional formatting question 2
Conditional formatting 0

Back
Top