Conditional formatting based on Table

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

Guest

I would like to apply conditional formatting to several fields of a report
based on a value found in one of the database's tables. The table is called
tblWarnings and has two fields - Red, Yellow. I would like to make the report
fields red if they exceed the Red table value and yellow if they exceed the
Yellow table value. I can't seem to figure out a way to reference the table
value (there will only be one record in the table).
 
Your tblWarnings should be structured like:

MinValue MaxValue WarningColor
0 100 Red
100 1000 Yellow

You could then use this table in your report's record source and include
WarningColor in the fields of the report.
 
Hi Jason,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 

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

Change text box background color depending on value in Label Reports 1
Conditional Formatting Problem 1
Conditional Formatting Headache 2
Conditional formatting not working 2
Conditional Formatting 1
Conditional Formatting 1
Reports that sift records from different tables 0
display the value depending on logical condition 2

Back
Top