conditional formatting 5 conditions
 

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

conditional formatting 5 conditions
 

On 25 Jun, 13:26, 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

No not in XL (2008 does)

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

conditional formatting 5 conditions
 

Bob Phillips has a free download CFPlus, available he

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 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

conditional formatting 5 conditions
 

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

conditional formatting 5 conditions
 

You're welcome.

Pete

On Jun 25, 5:05*pm, james b wrote:
thats great thanks!!