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.