Forum Discussion

Robert Hart's avatar
Robert Hart
Copper Contributor
May 14, 2020

DISPLAY NEGATIVE PERCENTAGES IN RED?

Is there a formula I where I can have negative percentages display as RED inside Paranthesis?   For example:  (-8.50%)  

2 Replies

  • peteryac60's avatar
    peteryac60
    Iron Contributor

    Robert Hart 

    Bob

     

    I think you just need to format the cells rather than use a formula.

     

    Something like the attached should work?

     

    Hope this is what you were looking for?

     

    Peter