No, but it's perhaps not intuitive, and perhaps a confusion with the
usage of "format" in "number format"...

The Help file isn't wrong, in that you can certainly include a format
containing a custom color, like "[Blue]0.00;[Red]0.00" - i.e., it won't
throw an error. So the Help file is correct.

But, like any other function, TEXT() returns a value to the cell, in
this case a text string. By definition, text strings carry no
font/color/etc. format information. Values are displayed according to
the cell format. So the text string will be formatted in the way the
cell's text format is specified.




In article ,
headly wrote:

In other words, the program isn't wrong, the help file is?