Add Personal Conditional Formatting

Applying Personal conditional formatting allows users, such as Administrators, to overlay conditional formatting on top of the globally applied formatting. This might be done to check how a new formatting rule looks before applying it as a Global formatting rule or by an individual to highlight things important to their role or current activities.

To create a personal conditional formatting rule:

1. Right-click on a column heading, the choose Edit Personal Conditional Formatting.

2. On displaying the Conditional Formatting dialog box, note that any globally applied formatting rules are displayed, but they are not editable.

3. Add your personal formatting rule.

4. After adding it, note that you can move it up or down in the list, within the constraints of the Conditional Formatting Precedence Rules, using the Move Up and Move Down buttons.

Note: The ability to place personal conditional formatting before global conditional formatting is role based.

5. After applying your changes and closing the dialog box, the table displays the personal and global formatting, but only you can see the personal formatting.