How can I get text to be shown in red if the value is less than 0.00?
E ewan7279 Mar 16, 2006 #2 Hi Andrew, Format => Cells => Custom, and in the Type bar enter: "0.00_ ;[Red]-0.00" (without the quotation marks. Ewan.
Hi Andrew, Format => Cells => Custom, and in the Type bar enter: "0.00_ ;[Red]-0.00" (without the quotation marks. Ewan.
