you will need to write a macro to do 9 colors.

"CHRIS K" wrote:

how do I get more than 3 conditional formats?
I want to shade the cells depending on the 9 values (criteria range) each
one a different colour

thanks
--
CHRISK