custom format for boolean values

[Guest]

I need to display boolean worksheet values not as TRUE or FALSE, but as "Y"
and "N" without the use of conditional formatting, macros or functions; a
custom format.

The custom format:
"Y";;"N";
works if the field value is numeric, but not for boolean expressions or
values.

 

[Peo Sjoblom]

Not possible unless you change the function that returns the TRUE or FALSE

Like if you have

=A2>5

change that to

=--(A2>5)

then use your custom format

"Y";;"N";