![]() ![]() 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |