A simple problem to describe...
=TEXT(A1,"$#,##0.00;[Red]-$,##0.00") where A1 is a negative number.
The negative value is not shown as red - always black.
The cell containing the formula can be formatted as general, number, text, currency - makes no difference.
Ideas ?
Excel 2003, btw
=TEXT(A1,"$#,##0.00;[Red]-$,##0.00") where A1 is a negative number.
The negative value is not shown as red - always black.
The cell containing the formula can be formatted as general, number, text, currency - makes no difference.
Ideas ?
Excel 2003, btw