Use this dialog to manage conditional formats and stoplight formats. For example, you might want to activate a conditional format that highlights costs that are greater than 100,000.
For more information, see:
"What is a conditional format?"
"About managing conditional formatting"
"Examples of conditional formatting"
Use this list to specify the conditional formats you want to show in the <Conditional formats list>. For example, you might want to show only active conditional formats and stoplight formats.
Use this list to see the existing conditional formats and stoplight formats that are available, and to select and edit formats.
Hint: Use the check box in the Active column to activate and deactivate a format. You cannot have an active conditional format and an active stoplight format on the same worksheet item at the same time.
Note: A red cross symbol is displayed next to a conditional format if it conflicts with another active conditional format. To resolve the conflict, either deactivate or delete one of the format that have a red cross next to them (for more information, see "About managing conditional formatting").
Use this button to display the "New Conditional Format dialog", which enables you to create a conditional format to highlight worksheet values.
Use this button to display the "New Stoplight Format dialog", which enables you to create a stoplight format to categorize worksheet values.
Use this button to display either the Edit Conditional Format dialog or the Edit Stoplight Format dialog, which enable you to edit the currently selected format in the <Conditional formats list>.
Use this button to remove the currently selected format in the <Conditional formats list> from the worksheet.
Use this button to display the "Stoplight colors dialog", which enables you to change the default color of unacceptable, acceptable, and desirable values for new and existing stoplight formats in the current worksheet.
This field displays additional information about the format. Use this information to help you decide which format you want to use. The default description is the condition part of the exception format syntax (for example, Profit SUM > 10,000).