Conditional formatting issue

[Ticotion]

Hi

I have a report showing the following
Week 1 Week 2 Week 3 ect.
Production line 1 80 50 100
Production line 2 10 30 90

I want to use conditional formatting on the numbers according to a master
data table that contains targets for each production line. The target for
production line 1 is 80, so everything between 80 and 100 should be green and
any other values red.
The target for production line 2 is 60 so everything between 60 and 100
should be green and below red.

My problem is how you make sure that the conditional formatting is used with
the right target on the right production line?

Can you please help

Ticotion

 

[Allen Browne]

Presumably you have a ProductionLine table (one record for each valid line)?

If so, this table could have a Target field (Number) containing the target
value for that line.

You could then include that field in the source query that feeds your
report, and set up the conditional formatting as:

= [Target]