Question ID: 1504 5/12
PREVIOUS QUESTION NEXT QUESTION

Format, automatically, the cell range A1:A100 to display numbers with two decimal spaces and a thousand separator, if they are higher than zero. If they are less than zero, numbers will be displayed with three decimal places and a thousand separator in red font color. If they are zero, the word Zero will be displayed in green font color.

Use custom number formatting.

 

 

Other versions
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2010Microsoft Excel 2013Microsoft Excel 2016Microsoft Excel 365

 

 

 


Format, automatically, the cell range A1:A100 to display numbers with two decimal spaces and a thousand separator, if they are higher than zero. If they are less than zero, numbers will be displayed with three decimal places and a thousand separator in red font color. If they are zero, the word Zero will be displayed in green font color.
Use custom number formatting.