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.