Coinditional formatting - press f1 ( help ) and type in conditional formatting.

If you cant do it, give me a shout.

ps Its even nicer nd easier on office 2007