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

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

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

Depends of course on how you are using it cut check this out.
http://office.microsoft.com/en-us/ex...CL100570551033

if that doesn't do it then some simple vb code will
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Una" wrote:

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

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