![]() |
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. |
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 |
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