Conditional Formatting (1 Viewer)

[nick5196]

I have a subtable containing a name and a percentage (score). I would like all of the percentages above the average to be green and those below the average to be red. I have tried "field is greater than Davg" however this proved unsuccessful.

Could anyone tell me the expression

Thanks
Nick

 

[vbaInet]

Let's see the expression you used.

 

[nick5196]

i didnt use an i expression, just selected field is greater than from the combos. Then typed Davg.
Im a novice...so not too sure about the expression.

 

[smig]

put the avarage in a field on the header/footer and compare to this field

 

[vbaInet]

put the avarage in a field on the header/footer and compare to this field

So there you have it from smig. The conditional format will be:

[COLOR=Blue][B]Expression Is[/B][/COLOR] [txtBoxToCompare] > [txtBoxInHeader/Footer]

where [txtBoxToCompare] is the name of the textbox bound to the percentage field and [txtBoxInHeader/Footer] is the textbox that contains the Average, i.e. =Avg([PercentageField]).