max min score

[spinkung]

hi all,

hopefully just a quicky.

I have a report with a table of scores for people. i'm trying to colour the highest score (max) green and the lowest (min) red.

can someone help me itha formula. i've never used conditional formatting before.

many thanks, spin.

 

[Galaxiom]

In the formatting conditions compare the field with the maximimum of minimum as appropriate.

Where QueryName is the query used to generate the subreport,
set the conditional formatting of the field FieldName to:

Field Value Is Equal To DMax("FieldName", "QueryName")

Field Value Is Equal To DMin("FieldName", "QueryName")