conditional formatting 5 conditions

J

james b

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
 
M

Matthew

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
Click to expand...

No not in XL (2008 does)

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