Conditional formatting by date-need to colour a cell

Hey all,

Today I am trying to do some conditional formatting and mostly failing. I need to colour a cell one of 3 colours depending on the date in another cell, but I'm not sure how to do that.

As an example, say cell A1 contained a date after 31/08/09 then cell A2 should be coloured red, and if it is before or on that date then cell A2 should be coloured green. I'm not sure how to write the formula for those in the contitional formatting though, so if someone could give me an example of one of them I'd very much appriciate it.

Thanks.

Create 2 rules

=(A1>"31/08/2009")
and format Red

=(A1<="31/08/2009")
and format Green

Update: If you format it Green as default you may get away with just setting up one rule

Hey, thanks for the reply. Unfortunatly that is not working. Now, regardless of what is entered in to cell A1, cell A2 is being coloured green.