Conditional formatting

[Versateo]

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

 

[Bob Phillips]

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