When you create a chart in Excel using positive and negative values, both positive and negative graphs are the same color by default. Another way to display the chart is to change the color of the ...

meaning the current value is a negative number, the expression is True, and Excel applies the format (the red font). Image: Susan Harkins/TechRepublic. This conditional rule displays the negative ...

Validation rules can change cells font, style, size or border. They can also change the text's color. For example, rules may highlight negative figures by printing them in red. Rules may also ...