Hi

i have 5 different stages of review gm,1st verbal, 2nd verbal, and so on, so
i want each one to have a different colour! in conditional formatting it only
allows 3 is there any way to extent this to 5?? i already have a formula in
the cell if that makes any difference!


thanks for any help

On 25 Jun, 13:26, james b <jam...@discussions.microsoft.com> wrote:
> Hi
>
> i have 5 different stages of review gm,1st verbal, 2nd verbal, and so on, so
> i want each one to have a different colour! in conditional formatting it only
> allows 3 is there any way to extent this to 5?? i already have a formula in
> the cell if that makes any difference!
>
> thanks for any help

No not in XL (2008 does)

You could check out Chip Pearson's web site he has a way of doing it
though.

Bob Phillips has a free download CFPlus, available here:

http://www.xldynamic.com/source/xld.....Download.html

This will give you up to 30 conditional formats in each cell.

Hope this helps.

Pete


On Jun 25, 1:26*pm, james b <jam...@discussions.microsoft.com> wrote:
> Hi
>
> i have 5 different stages of review gm,1st verbal, 2nd verbal, and so on,so
> i want each one to have a different colour! in conditional formatting it only
> allows 3 is there any way to extent this to 5?? i already have a formula in
> the cell if that makes any difference!
>
> thanks for any help

thats great thanks!!

"james b" wrote:

> Hi
>
> i have 5 different stages of review gm,1st verbal, 2nd verbal, and so on, so
> i want each one to have a different colour! in conditional formatting it only
> allows 3 is there any way to extent this to 5?? i already have a formula in
> the cell if that makes any difference!
>
>
> thanks for any help

You're welcome.

Pete

On Jun 25, 5:05*pm, james b <jam...@discussions.microsoft.com> wrote:
> thats great thanks!!
>