For doing this, select the status cells > click on the Home tab > click on Conditional Formatting > click on New Rule… Moreover, you can also set the format for the Status column.Similarly, you can set formats for medium and low priority tasks too.Now, the New Formatting Rule window will appear again with a format preview.Go to the Fill tab of the window and choose the fill color you want to set. At this time, the Format window will appear.Click on the Format button to set the formatting. Now, if you are setting the format for high priority, write High in the right side text box. Subsequently, choose the Specific text option from the Format only cells with: drop-down list. Choose the Format only cells that contain option from the Rule Type options.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |