Conditional Formatting In Reports

  • Thread starter Thread starter DFDGirl
  • Start date Start date
D

DFDGirl

Hi there,

I have a monthly report that I am creating which calculates the amount
spent in relation to what was budgeted for. Thus I have a calculation
that is a percent.

What I would like to do is set my conditional formatting to acknowledge
the percents greater than 25% and highlight in yellow.

What I am getting are .02 or .53's highlighted in yellow but really no
rhyme or reason and definitely not a .25.

Any suggestions?
 
Presumably you have a couple of numeric fields called Actual and Budget, and
a calculated percentage that has a Control Source of:
=([Actual] - [Budget]) / [Budget]

To format this calculated control, select it in report design and choose
Conditional Formatting on the Format menu. Set Condition 1 to something like
this:
Expression ... (Abs(([Actual] - [Budget]) / [Budget]) > 1.25
 
Back
Top