Alan,

You need VBA to have more than 3 conditions. However, there is an add-in
that does it all for you at
http://xldynamic.com/source/xld.CFPlus.Download.html

--
HTH

Bob Phillips

"Versateo" wrote in message
...
When using the conditional formatting dialog box, if you want more than
one
condition to apply, you click the ADD button. However, you can only do
this
twice, i.e. you can only apply a maximum of three conditions. Is there any
way round this limit, if you want more than three conditions?

Any ideas folks?

Regards
Alan