Set a Column or Row Attribute

Use this procedure to set the row or column attributes of a spreadsheet.

To set the attributes of a spreadsheet row or column:

1. In the Project Views folder of Open Plan Explorer, select a project to display in spreadsheet view.

2. From the Table menu group of the View tab, select Conditional Formatting.

3. Click the first row of the Applies To column, and using the selection list, choose the column you want to format.

   You can also select < Rows > to specify attributes for all rows meeting the criterion.

4. You may choose to make the formatting conditional by specifying a Criterion.

5. Using the remaining columns in the rules grid, specify the appearance and contents of the column or rows.

6. When finished, click OK.

Related Topics

• Spreadsheet View Overview
• Conditional Formatting Dialog Box
• Calculated Fields
• Add Column Dialog Box
• Edit Column Dialog Box
• Insert Column Dialog Box
• Spreadsheet Preferences dialog box

Related Procedures

• Enable Grouping
• Customize Display Options
• Edit a Column
• Add a Column
• Insert a Column
• Sort Spreadsheet Data