Hi,

I have defined a dropdown, by using a Data>Validation>List..

Now it has got 5 values say 1 ,2 ,3, 4 and 5

Now my requirement is , I wnat to change the color of the cell depending on
the value I select from the text.say if 1 is selected then it should be red
and 2 is selected it should be greeen and so on..

I tried using FORMAT>CONTIONAL..but this is restricted to only 4 , I have
condtion to check for more than 4 say 5 or 6..

Looking forward for reply.
--
Programmin