Thanks for the comeback Nick......I couldn't figure out how to do it and
thought it was just me..........I'm struggling now trying to do it with code,
but not having much luck at that either.....

Vaya con Dios,
Chuck, CABGx3



"Niek Otten" wrote:

Hi Chuck,

Not that I know of, at least not with 3 other conditions.
Normally the format code is divided into three zones: one each for positive, negative, zero, text.
But if you use it for self-defined conditions, I have not found a way to have 3 conditions and an ELSE branch.

Maybe someone else?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CLR" wrote in message ...
| That's very cool Nick, and certainly a keeper. It does exactly what the OP
| asks for, however, it will also return a "no" for any other number besides 0,
| 1, or2 in my XL97. Is there a way to change it to allow the other numbers to
| show as typed?
|
| Vaya con Dios,
| Chuck, CABGx3
|
|
|
| "Niek Otten" wrote:
|
| There is this ancient Format feature where you can specify up to 3 conditions plus an Else branch.
|
| FormatCellsNumber tab, Custom. In the Type box, enter something like
|
| [=1]"yes";[=2]"Not enough info";"no"
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
|
| "lindasuenwh" wrote in message
...
| |I have looked all over and have to finish this report asap. Help is not
| | helping. How do I format a cell to return a word when I input a number? For
| | example, "2" = "Not enough info" or "0" = "No"?
| | Thanks -
| | Excel newbie
|
|
|