"keith" wrote:
Can anyone tell me how I could change the colour of a cell based on a 10 line
argument? as conditional formating will only allow three conditions

You might want to check out Bob Phillip's:
CFPlus - Extended Conditional Formatter, at his:
http://www.xldynamic.com/source/xld.....Download.html

Believe it can handle, quote:
Multiple Conditional Formats, up to 30 in total for any range of cells

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---