How to convert true false to checkbox in Excel?

Let’s say you have listed numbers in two columns, if the number in the first column is bigger than that in the second column, display TRUE, otherwise display False as below screenshot shown. Now you can change the formula to convert TRUE or FALSE to checkbox marks easily in Excel.

Change the original formula to =IF(original_formula,"þ","¨")

1. In this case, I use the formula =B3>C3 to compare the numbers in two columns. Therefore, I will change the original formula as below, and then drag the AutoFill handle to other cells.

=IF(B3>C3,"þ","¨")

2. Keep the formula cells selected, right click, and select Format Cells from the context menu.

3. In the Format Cells dialog, go to the Font tab, select Windings from the Font list box, and click the OK button.

Now you will see the special characters are converted to ticked checkboxes and unticked checkboxes. See screenshot:

This section will introduce a VBA macro to convert multiple true and false to checkbox controls in Excel. Please do as follows:

1. Select the cells equal to “TRUE” and “FALSE” you will convert to checkboxes.

2. Press Alt + F11 keys together to open the Microsoft Visual Basic for Applications window.

3. Click Insert > Module, and then paste below VBA code into the new Module window.

VBA: Convert TRUE and FALSE to checkbox controls in Excel

Sub ConvertTrueFalseToCheckbox()
Dim xCB As CheckBox
Dim xRg, xCell As Range
Application.ScreenUpdating = False
On Error Resume Next
Set xRg = Selection
For Each xCB In ActiveSheet.CheckBoxes
xCB.Delete
Next
For Each xCell In xRg
If (UCase(xCell.Value) = "TRUE") Or (UCase(xCell.Value) = "FALSE") Then
Set xCB = ActiveSheet.CheckBoxes.Add(xCell.Left, xCell.Top, cDblCheckboxWidth, xCell.Height)
xCB.Value = xCell.Value
xCB.LinkedCell = xCell.Address
xCB.Text = ""
End If
Next
Application.ScreenUpdating = True
End Sub

4. Press F5 key or click the Run button to run this VBA.

Then you will see all selected TRUE and FALSE are converted to checkbox controls. TRUE is converted to a ticked checkbox, and FALSE is converted to an unticked checkbox. See screenshot:

If you have Kutools for Excel installed, you can apply its Batch Insert Check Boxes feature to insert multiple checkbox controls in bulk with one click in Excel.

Kutools for Excel- Includes more than 300 handy tools for Excel. Full feature free trial 60-day, no credit card required! Get It Now

1. Select the cells equal to “TRUE” and “FALSE” you will convert to checkboxes, and click Kutools > Insert > Batch Insert Check Boxes.

2. Now a checkbox control is inserted into every selected cell. You can manually tick these checkboxes as you need.