can this be done

  • Thread starter Thread starter RA
  • Start date Start date
R

RA

I may be in the wrong forum but here we go..

I want to have my report highlight/change font color, or
some other type of identification, when the calculation
being reported falls out side a moving standard.

For Example:
Month 1:
Joe worked 2 hours, Mary 10 hours, Jill 12 hours, Harry,
11 hours
Month 2: Joe worked 12 hours, Mary 9 hours, Jill 7 hours,
Harry 9 hours

The report would highlight Joe's hours in month 1 because
it is outside the norm. but no highlighted hours because
no hours are far outside the norm.

RA
 
I'm not sure what you mean by a "moving standard", but
check out Help on Conditional Formatting (Format,
Conditional Formatting from Report Design view).

You can conditionally format a control depending either on
its value or the value of an expression which returns True
or False. I believe your expression could then use a
custom function that defines your moving standard.

HTH
KS
 
Back
Top