Highlight cell backgrounds

In Microsoft Office Project 2007, you can highlight cells in a sheet (sheet: A spreadsheet-like representation [in rows and columns] of task or resource information. Each row specifies an individual task or resource. Each column [field] specifies a type of information, such as start dates or standard rates.) view to display a different background color. You can choose to highlight specific cells or you can highlight cells that meet certain criteria, such as milestone (milestone: A reference point marking a major event in a project and used to monitor the project's progress. Any task with zero duration is automatically displayed as a milestone; you can also mark any other task of any duration as a milestone.) or external tasks (external task: A task that represents a linked task in another project, providing an easy way to review the attributes of linked tasks without switching between projects. An external task can be changed only in the source project.).

Highlight individual cells

  1. In a sheet view, click the cells that you want to highlight.
    • To select multiple cells that are not next to each other in the list, hold CTRL and click each cell that you want to highlight.

 Note   You can select up to 10 cells at one time.

  • To select multiple cells that appear consecutively in the list, click the first cell that you want to select, hold SHIFT, and then click the last cell in the list that you want to select.
  1. On the Format menu, click Font.
  2. Change the font options for the selected cells, including selecting a new background color from the Background Color list.

Top of Page Top of Page

Highlight categories of cells

  1. On the Format menu, click Text Styles.
  2. Select the category of cells that you want to highlight from the Item to Change list.

Options that include a background color are:

  • Critical Tasks    Select this option to highlight the cells for tasks with the Critical field set to Yes.
  • External Tasks    Select this option to highlight the cells for tasks that are tracked in another project.
  • Highlighted Tasks    Select this option to highlight the cells for tasks that meet a filter's criteria when displaying all tasks in a filtered task list.
  • Marked Tasks    Select this option to highlight the cells for tasks with the Marked field set to Yes.
  • Noncritical Tasks    Select this option to highlight the cells for tasks with the Critical field set to No.
  • Milestone Tasks    Select this option to highlight the cells for tasks with the Milestone field set to Yes.
  • Summary Tasks    Select this option to highlight the cells for summary tasks.
  • Changed Cells    Select this option to highlight cells that have changed as a result of changing specific data.
  1. Change the font options for the selected category of cells, including selecting a new background color from the Background Color list.

Top of Page Top of Page

 
 
Applies to:
Project 2007