ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I get the font color to change automatically depending on (https://www.excelbanter.com/excel-discussion-misc-queries/10899-how-do-i-get-font-color-change-automatically-depending.html)

gtcarlsbad

How do I get the font color to change automatically depending on
 
How do I get the font color to change automatically depending on whether it
is a positive or negative number? Example: if negative auto change to red,
If positive number change to green, zero balance auto change to black.

Dave Peterson

Take a look at Format|Conditional formatting.

gtcarlsbad wrote:

How do I get the font color to change automatically depending on whether it
is a positive or negative number? Example: if negative auto change to red,
If positive number change to green, zero balance auto change to black.


--

Dave Peterson

peterm

Go to Format - Conditional format
Is very easy to use

"gtcarlsbad" wrote:

How do I get the font color to change automatically depending on whether it
is a positive or negative number? Example: if negative auto change to red,
If positive number change to green, zero balance auto change to black.



All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com