Cells color automatically dependant on value
 

I have been using conditional format to colour cells depending on value,
however, I want to use more than 3 colours,

can anyone think of a good solution?
Many you for your help

Cells color automatically dependant on value
 

try this I found it very useful

http://www.xldynamic.com/source/xld....nload.html#top

Andy

"conradJ" wrote:

I have been using conditional format to colour cells depending on value,
however, I want to use more than 3 colours,

can anyone think of a good solution?
Many you for your help