How to make checkbox checked based on cell value in Excel? - ExtendOffice
https://www.extendoffice.com/documents/excel/3996-excel-checkbox-checked-based-on-cell-value.html
Make checkbox checked based on cell value with formula 1. After inserting the check box (Form Control), select it and link it to a specified cell C2 by entering =C2 into the Formula Bar. ... 2. Select the lined cell (C2), then enter formula =IF (A2="Test",TRUE,FALSE) into the Formula Bar, and then press the Enter key. ... 3. When entering value “Test” into cell A1, the corresponding checkbox will be checked automatically. ...
1. After inserting the check box (Form Control), select it and link it to a specified cell C2 by entering =C2 into the Formula Bar. ...
2. Select the lined cell (C2), then enter formula =IF (A2="Test",TRUE,FALSE) into the Formula Bar, and then press the Enter key. ...
3. When entering value “Test” into cell A1, the corresponding checkbox will be checked automatically. ...
DA: 80 PA: 62 MOZ Rank: 10