color expression for numberintervall

[beck_bakytbek]

Hi Folks, i got a Question regarding of Color Expression. my data does look like:

Numbers:

0

-5

-10

how to build the Color Expression for intervall of data, i mean

>0 , green(),

and between 0 and -5 , White,

and between - 5 and  - 10, yellow,

> - 10, red

i tried to bield with "and", but it does not work.

Does anybody have any idea?

Thanks a lot

[lironbaram]

hi 

the straight forward method will be 

if (number >0 , green() ,

      if(number<=0 and number >-5, white(),

            if(number <-10 , red(),yellow())))