Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

table conditional formatting less than 0

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 ...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous 

    In place of percent choose number

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous 

In place of percent choose number

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

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

    any more suggestion?

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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