Forum Discussion

kentusn's avatar
kentusn
Copper Contributor
Apr 10, 2023

Excel if results < 0 display character in red and if results > 0 display a character in green

I want a cell to display red characters if the results show a negative % and green characters if the results show a positive %

Excel
Excel for web
Formulas and Functions
office 365
  • davidleal's avatar
    davidleal
    Iron Contributor
    Apr 10, 2023

    kentusn have you tried to use Conditional Formatting?

    From the Ribbon select Conditional Formatting for your case you can select the predefined rules:

    then to specify the value on each case. You can edit the predefined color setting to your needs.

    • kentusn's avatar
      kentusn
      Copper Contributor
      Apr 10, 2023
      Not quite what I was looking for but it is better than I expected. Thanks a lot.
  • PeterBartholomew1's avatar
    PeterBartholomew1
    Silver Contributor
    Apr 10, 2023

    kentusn 

    Applying colours to numbers is standard number formatting.  For example, the two columns

    are identical other than the number formatting which changes their appearance.

    The custom format applied to the second column is

    [Color10]0%;[Red]-0%;"-";@

    I would have used [Green] but it is too light to show against a white background.

     

Resources