Undocumented non-feature.

Functions return values to their calling cells - they can't change cell
format.

TEXT() returns a text string to the cell according to the specified
format, rather than actually changing the format.

Since the format isn't changed, neither is the displayed result.

Instead of using TEXT(), use Conditional Formatting (see Help) instead.




In article <D2EF6C4A-2D0C-4AB1-8CD2-B582321D0D8E@microsoft.com>,
headly <headly@discussions.microsoft.com> wrote:

> Or just an undocumented non-feature;
> According to MSFT:
> TEXT(value,format_text)
> Where:
> Format_text is a number format in text form from in the Category box on
> the Number tab in the Format Cells dialog box.
>
> So: If Cell A1 has the number 2, in cell B1 I put a formula
> =Text(A1,"[red]0.00;[blue]0.00")
> where
> [red]0.00;[blue]0.00 works just fine as a number format from the category
> box of the Number tab in the Format Cells dialog box.
>
> Thougths appreciated.