Using Excel to create business forms means including elements available on your Web-based and paper forms, including check boxes. Like other Excel form elements, check boxes appear on the drawing ...

Once, if you wanted to add checkboxes to your Excel spreadsheet ... bottom-right corner of the formatted table) downwards, the new row will automatically contain the checkbox and the status ...

To highlight a cell or row in Excel ... to add the conditional formatting when the check box is selected, for instance, in the photo, we have highlighted a row containing Staff. A New Formatting ...

The next step is to add the drop-down list as follows: Specify the source of the list and the color names in A2:A5. Figure C shows the new list. If you choose an item, Excel will display it in the ...