Software

Ask something
Discussion Locked

colouring an excel field when positive

0 helpful
6 replies

by jimmy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a command in Excel that can change colours depending if the value is positive or negative. If it is positive i would like it to display the value in Red say and if it is negative i would like the value to be displayed in black.

Many thanks to all who take the time to answer

6 replies

by dklippert

Highlight the cells that are involved. Now go to Format>Conditional Formatting.
Use the option Cell value is greater than 0
Choose the desired formatting and click OK

by lord foul

The other way to do it is to firstly select the cells you wish to apply the formatting to.
From the menu bar click Format>Cells (Ctrl+1) and in the Category box choose, Number and in the negative number box click on the red number format and then click OK, for your solution!

This discussion is closed to new replies.