- To open the custom format, right-click on a cell and select Format Cells or CTRL+1 shortcut.
- Under the custom category, add the custom format [=1]”Yes”;[=0]”No”.
- Click OK.
Sandhya Answered question July 6, 2023
Not a member yet? Register now
Are you a member? Login now