Use this dialog to create a conditional format to highlight exceptional data for a worksheet item. For example, you might want to highlight sales figures greater than 100,000 by displaying them with a blue background.
For more information, see:
Note: You can only have one active conditional format or stoplight format for each numeric worksheet item. For example, to activate a conditional format on a worksheet item that has a active stoplight format, you must first deactivate (or delete) the existing stoplight format.
What would you like to name your Conditional Format?
Use this field to specify a short name for the conditional format. The name you specify is used to identify the conditional format on other dialogs. If you want Discoverer to create a name for you, select the Generate Name Automatically check box.
What description would you like to give your Conditional Format?
Use this field to enter a brief description for the new conditional format. This description is displayed in the Description field on the Conditional Formats dialog and helps workbook users choose which conditional format they want to use.
Use this drop down list to select the worksheet item you want to apply the conditional format to. For example, to highlight costs greater than 100,000 you might choose an item called Cost SUM here.
Use this drop down list to select the conditional operator (for example, = for equals, > for greater than, < for less than) you want to use to match against the worksheet item selected. For example, to highlight costs greater than 100,000 you might choose greater than (that is, >) here.
Use this field to enter the value you want to match against or select a value from the drop down list. For example, to highlight costs greater than 100,000 you might enter 100,000 here.
Hint: For date items, choose Select from Calendar from the drop down list to specify a date using the graphical "Calendar dialog".
Use this button to display the "Format Data dialog: Format tab" dialog, where you specify the color and text style for the worksheet item specified in the Item field when it meets the condition you specify in this dialog.
For example, to highlight sales figures greater than 100,000 with a blue background, use the "Format Data dialog: Format tab" dialog to choose a blue background color.
Hint: Use the Example box to see how a conditional format looks on the worksheet.