table conditional formatting less than 0

[Anonymous]

Hi, 

i am trying to format my table. rule is simple

  1. if less than 1 then  downward red arrow

  2. if equel to 1 then  

  3. if bigger than 1 then upward green arrow

however i am not able to do this simple rules

1, I may have nagitive number, but the first rule not let me input the nagitive number 

2. I only have simple rule, if i do can input the nagitive number but i WNAT everything just below 1 which means I need to put 'negative infinity' there. could I just only have one part of condition ?

thank you!

[amitchandak · Accepted solution]

@Anonymous 

In place of percent choose number

[Anonymous]

Thank you finally understand the logic. and just add, if wanted nagitive number, we do not need to put -10000 but just leave it blank

[Anonymous]

@amitchandak I changed to number still not able to input negative numbers. 

any more suggestion?