Hey there!
To display boolean worksheet values as "
Y" and "
N" without the use of conditional formatting, macros or functions, you can follow these steps:
- Select the cell or range of cells that contain the boolean values you want to format.
- Right-click on the selected cells and choose "Format Cells" from the context menu.
- In the "Format Cells" dialog box, select the "Custom" category.
- In the "Type" field, enter the following custom format:
Formula:
[=TRUE]"Y";[=FALSE]"N";
- Click "OK" to apply the custom format to the selected cells.
That's it! Now your boolean values will be displayed as "
Y" and "
N" according to their respective values.