Forum Discussion
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 %
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.
- Not quite what I was looking for but it is better than I expected. Thanks a lot.
