Help with changing the backcolor based on criteria

[d1004]

I am having with changing the back color based on the criteria. Basically, if cost2 field is greater than cost1 field, display the data with green back color. Otherwise, display data with white back color. In the control source property, I click on the Expression Builder to write my IIF statement.

IIf([cost1] > [cost2], [cost] AND [cost].backcolor = 108854, [cost] AND [cost].backcolor = 567893)

I think my code and syntax are probably not correct, so can you help me with this problem.

Thank you so much
Di

 

[Garridon]

You can actually do this with conditional formatting. Click on the field, select Format>Conditional Formatting.

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com