See my response earlier.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"CHRIS K" wrote in message
...
How?
have nt done one before!
--
CHRISK


"bj" wrote:

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