Hi Una

Bob Phillips has an Add in to use more formats at his site
http://xldynamic.com/source/xld.CFPlus.Download.html


--
Regards

Roger Govier


"Una" wrote in message
...
Hi John

Thanks, could you let me into this trick?
Regards

Úna

"John Bundy" wrote:

You can trick it into doing 4 but not five unless you build a program
in vb.
--
-John
Please rate when your question is answered to help us and others know
what
is helpful.


"Una" wrote:

Hi

I was just wondering whether there was a way that I can add more
than three
conditional formats. I have five different options from a drop down
column
that I want to give a different colour for reporting. I would
appreciate any
help.

Many thanks

Úna