Article ID: 133049 - View products that this article applies to.
This article was previously published under Q133049
In Microsoft Excel, a function cannot automatically format text based on the type of value it returns. However, you can create a custom number format that will return different colored text, based on whether your function returns a positive, negative, or zero value.
In Microsoft Excel, number formats are based on the following:
To have a function return up to three different types of text value, each with a different color, have the function return either a positive number, a negative number, or a zero value, and format the custom number format such that it displays text based on those values. For example, the following custom number format
[color1]positive# format;[color2]negative# format;[color3]zero# format
will display the word "after" in red if the function returns a positive number, the word "before" in blue if the function returns a negative value, and the word "same" in green if the function returns 0.
"User's Guide," version 5.0, Chapter 12, "Formatting a Worksheet"
For more information about Custom Number Formats, choose the Search button in Help and type:
number formats, creating custom
Article ID: 133049 - Last Review: August 19, 2003 - Revision: 1.1
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.