Only with a macro. To make it "dynamic", this would have to be a an event
macro, say Worksheet_Change.

Have you considered just alternating two colors instead of 5 different ones?

On Wed, 27 Oct 2004 14:57:20 -0500, Richie Rich
wrote:


Hi

I use Conditional Formatting quite frequently but I find it so
restricted when you can only set it to 3 searches, say for example,
find numbers between 1-10 in 1 colour, 11-20 in another & 21-30 in
another. How can I extend it to create more colours searches say,
numbers between 31-40 and then 41-50 in different colours? Can this be
done?

Thanks in advance

Richie Rich (new user)