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