Conditional formatting based on Table

J

Jason

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).
 
D

Duane Hookom

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.
 
W

Wei Lu [MSFT]

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.
 
Top