Using Conditional Formatting

[Using IFS Enterprise Explorer Clients] [Searching & Organizing Information in IFS Enterprise Explorer] [To Searching and Organizing in Enterprise Explorer]

Explanation

Conditional Formatting is very useful when you want to highlight certain information in an IFS Applications table/overview page. For example, you might want to highlight credit invoices, or you might want to highlight supplier invoices exceeding a certain amount or inventory parts where available quantity is below a certain number. You can set up different types of conditions to control text style, text and background color and to combine several formatting rules for one column/page. Your conditional formatting rules are personal and stored in your user profile.

Figure 1: Result of applying rule based formatting for displaying data in a table
 

Prerequisites

N/A

System Effects

N/A

Window

N/A

Related Window Descriptions

N/A

Procedure

Using Conditional Formatting

  1. Open an IFS Applications table/overview page. Right-click on the column header of the column you want to create conditional formatting for and choose Conditional Formatting from the context menu.




    Figure 2: How to open the Conditional Formatting dialog box
  2. The Conditional Formatting dialog box is displayed. Click New Condition button to start creating a rule. You can also press Alt + N to do the same. It is possible to create several rules for one column.



    Figure 3: Dialog box for Conditional Formatting
     
  3. For each rule you specify Value, Text Style, Text Color, Background Color, see below:
  1. Once you have specified all rules click OK button to save your changes and the rules will be applied on the page.




    Figure 4: Dialog box for Conditional Formatting after creating rules

The Conditional Formatting dialog contains the following buttons/options:

Modify a Conditional Formatting

  1. Right-click on the column header  and choose Conditional Formatting from the context menu.
  2. The Conditional Formatting dialog box is displayed. All columns are available in the Column list. Select the column you want to change, columns with an existing rule are highlighted with bold font. The formatting rule is displayed and you can make changes, add new formatting rules to the column or delete formatting rules.
  3. To remove all formatting rules for the page, click Reset Formatting or use shortcut key Alt + R. A dialog box is displayed asking for you to confirm the removal of formatting rules.
  4. If you want to delete a rule, click Delete Condition. You can also press Alt + D to do the same. (This option is enabled if a rule exists only)
  5. Click OK button to save your changes