Forum Discussion

rsch91's avatar
rsch91
Icon for Helper I rankHelper I
2 years ago
Solved

Conditional formatting negative value

Hi,   I'm trying to format a table conditionally. The table contains negative values, data type is percentage. Anything over 15%, positively or negatively, should be red. Anything within the -15% a...
Need Help
  • miTutorials's avatar
    miTutorials
    2 years ago

    Since the data type is percentage - when you enter 15 it turns out to be 1500%. You will have to change the value to 0.15 for 15% and 1 for 100%. 

miTutorials's avatar
miTutorials
Icon for Super User rankSuper User
2 years ago

Since the data type is percentage - when you enter 15 it turns out to be 1500%. You will have to change the value to 0.15 for 15% and 1 for 100%. 

  • rsch91's avatar
    rsch91
    Icon for Helper I rankHelper I
    2 years ago

    Of course, makes a lot of sense. Thank you. It's worked.