One method I like is using a data validation drop-down list because it works pretty well in Excel on touch-enabled devices, and it is also compatible with most versions of Excel and OpenOffice and Google Sheets.
I wish Microsoft would add an in-cell checkbox feature (Apple's Numbers software does it), but until they do that we have to come up with clever alternatives. If you don't see the Developer tab, go to File > Excel Options > Customize Ribbon and find and check the Developer tab. The form field checkbox is found in the Developer tab shown in the image below. They may be nice for a spreadsheet layout that is not meant to be modified, but so far I haven't found a to do list that I haven't wanted to modify frequently. If you like to sort and delete and insert rows, form fields get all messed up.
You can see this demonstrated in the Simple Task Tracker below. If you want to use a numeric priority like 0-4, then you can use Icon Sets to display images instead of (or in addition to) the numeric value. The image below shows how to get to the correct option from the Home tab.ģ. Enter the word high and choose the "Light Red Fill with Dark Red Text" option.Go to Home > Conditional Formatting > Text That Contains.Select the cells in the Priority column.Follow these steps to create the type of formats shown in the example above. This can be done automatically and is a great way to easily identify your high-priority tasks. In the example above you will see that the values in the Priority column have been highlighted differently. Conditional Formats for the Priority Column