"Rick Rothstein" wrote:
A slightly simpler format pattern that can be used
to do this is...
"On";;"Off"

Right. Klunk!

That's what I started with. But when it did not work with cell values of
TRUE and FALSE, I moved on to conditional custom formats, still trying with
TRUE and FALSE (e.g. [=TRUE]"on"). And when that did not work, I simply
tweaked the conditional custom format to use 1 and 0. Which still did not
work with cell values of TRUE and FALSE, of course; hence the requirement to
actually use 1 and 0. At that point, I shoulda started back Square One.
But I was stuck in a particular mindset. Klunk!

Thanks for posting the better custom format.


----- original message -----

"Rick Rothstein" wrote in message
...
If the cell value is 0 or 1, not FALSE or TRUE, you can use the following
Custom format to display "off" or "on":

[=0]"off";[=1]"on"

A slightly simpler format pattern that can be used to do this is...

"On";;"Off"

--
Rick (MVP - Excel)