Conditional Formatting Based On Another Column

[Rustin788]

Hey,

I have looked at several different places and still can't quite figure this out. I am trying to run conditional formatting in a report that is based on two different fields. Below is a small example of the data. Each branch has a % increase that should have occurred because of a price increase. For instance Branch 3 is expected to have increased by 4% and Branch 38 by 2%. What I would like to do is include condition formatting where if they did not meet their requirement the percentage is red. So something like: If Branch = 3 and % Increase < .04, make red.

Branch	Customer	% Increase
3	AMERICA	3.8%
17	AMERICA	5.8%
38	AMERICA	3.12%

Thanks For Any Help

**EDIT: Thanks pbaldy

[pbaldy]

You'd use Expression Is and an expression of:

[Branch] = 3 and [% Increase] < .04

though if you have too many conditions you'll have to switch to VBA in the format event of the appropriate section. I'd probably make both conditions part of the data so I could include the percentage in the data and simply have:

[% Increase] < [TargetPercent]

[Rustin788]

Awesome, thank you. I was trying to work it out using an IIf statement in the Expression Is box.

[pbaldy]

No problemo!