Hi Roy,
See xlDynamic's CFPlus addin which is downloadable, free of charge, at:
http://www.xldynamic.com/source/xld.....Download.html
---
Regards,
Norman
"Roy DCunha" <Roy
(E-Mail Removed)> wrote in message
news:8F1511F7-7CF0-4FA2-B6FF-(E-Mail Removed)...
>I would like to format the cells using conditional formating but
> unfortunately it allows only for three conditions.
>
> I would like to use a no.of color combinations for different combinations.
>
> Pls can you help in this regard.
>
> Thanks,
> Roy