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.