Heelp...Conditional format for more than 3 conditions

[sdeppe]

Hello,

I need to apply five colors to certain cells . These colors must be dependent on another cell's value which in turn varies.

How do I write a macro for this? Any examples out there?

THANKS A LOT
And Greetings from Nuremberg / Germany

 

[Sir Vili]

Take a look:

http://www.mrexcel.com/board/viewtopic.php?topic=16368&forum=2

Brgds Sir Vili