The simplest checkbox to make using a drop-down list is probably just a list with a single character (x), or you could use a special character like the square root sign (√) that looks like a check mark in some fonts. 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. The image below shows you how to modify the settings for this rule.Go to Home > Conditional Formatting > Icon Sets > More Rules.Create a drop-down list with the options 4,3,2,1.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

In the Source field enter a comma-delimited list such as High,Medium,Low 2.

To create a simple drop-down list, follow these steps: It's very handy to use an Excel drop down list for columns like these. Many task lists include a Priority or Status column, such as the Homework To Do List shown below. Simple Drop-Down Lists via Data Validation Conditional Formats for Numeric Priorityġ.Conditional Formats for the Priority Column.Simple Drop-Down Lists via Data Validation.

Youtube date drop down in excel