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)