Conditional format depending upon another field

[lovemuscle2005]

Hi All

I have a report running of a simple query which holds Actual performance and target performance.

I need to conditionally format the actuals cells depending on if the person hits the performance cells.

Any ideas anyone? Thanks

P.S.
I hate work

 

[Joe4]

Did you mean to post this on the Access site or the Excel site? There really aren't any cells or conditional formatting that I now of in Access, though you may be able to do something (color changes) to records on a report with VB.

 

[Andrew Fergus]

There is a conditional formatting option in the report design, select a field, Click Format -> Conditional Formatting but AFAIK you can only apply the format based on the values in that field. I believe LM2005 wants to set the format of the 'actual' field based on a comparison of the 'actual' value with the value in the 'performance' field. The only way I can think of is it to create another field being [actual]/[performance] and set the conditional formatting on that (<1 or <100% use red etc.)
HTH, Andrew.

 

[Norie]

Andrew

Your right about the conditional formatting for reports but only in later versions.

 

[Andrew Fergus]

Oops - my bad! For previous versions that don't have conditional formatting, how about something like this in the (third, i.e. a/p ) field format?

+0.00%;-0.00%[Red]

This could be modified to accommodate other formats. Pretty basic I know but it may be enough for the OP.

Andrew