Creating More Than 3 Conditions Using Conditional Formatting?

[SpiritedAway]

Is there a straightforward way of creating more than 3 conditions using conditional formatting in an Access 2007 form.

I am scoring a document. On my form there are 4 dropdrop boxes each with a score between 1-4. As I score, I'd like the "final score" field to add up the total and if the score is between 1-6 the "final score" field will turn background green, if its between 7-12, the field background will turn orange and if its greater than 13 the "final score" field turn background red.

Is there a simple approach to this at all?

Thanks

SpiritedAway

 

[DCrake]

Access has a limit of 3 conditions, 4 if you count the default colour, however here is a link to a sample app that extends the feature.

http://www.access-programmers.co.uk/forums/showthread.php?t=154634

David