Try this, Jim:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90

*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jimbo" wrote in message
...
There are a possible 5 different conditions which I wish to use to
determine
the colour of a given cell. Each condition should result in a different
colour.
Using the "wizard" I get a maximum of 3 colours.
Is there a slick way around this limitation?