I don't think you can colour cells using functions - I think you have to use VB script to do that.

It's been a while since I played with Excel in anger though...
_________________________
Mk2a RioCar 120Gb - now sold to the owner of my old car
Rio Karma - now on ebay...