Color-coding dispatch statuses

Use the Operator condition type to add one or more OR conditions based on an arithmetic operator (such as equal to, greater than, or less than) or on a true condition.

This example illustrates how to set up a conditional format in the Order Scroll window that will change the font color of the entries in the Status column based on the following order statuses:

  • Available orders should display in green.

  • Planned orders should display in blue.

  • All other orders should display in the default color, black.

You must set up multiple Operator conditions, one for each dispatch status for which you want to change the font color: Available and Planned.

You must retrieve data before setting conditional formatting for a column.

  1. Go to The Order Scroll window opens.

  2. Retrieve order data.

  3. Right-click the column header.

  4. From the shortcut menu, select Conditional Format.
    The Add Condition/Appearance Mappings window opens. A single condition row appears in the grid by default.

  5. In the Select a condition type field, select Operator.

    image6

  6. In the Operator field, select = Equals if it is not already selected.

  7. In the Value field, type

  8. Select the Is Case Sensitive checkbox if it is not already selected.

  9. Select the font and fill color for the Available status.

    1. Click image9 Styles.

    2. Click Custom Style.
      The Custom Style Properties window opens.

    3. In the Font Color field, change the font color to green. You can do this by typing 0, 255, 0 in the field or by following these steps:

      1. Click the arrow in the Font Color field.
        A drop-down menu opens.

      2. Click the Web tab.

      3. Select Green.

    4. In the Fill field, change the fill color to white. You can do this by typing 255, 255, 255 in the field or by following these steps:

      1. Click the arrow in the Fill field.
        A drop-down menu opens.

      2. Click the Web tab.

      3. Select White.

    5. Click OK.
      The Custom Style Properties window closes.

  10. Select the font and fill color for the Planned status.

    1. Click Add Condition.
      A new condition row appears in the grid.

    2. In the Select a condition type field, select Operator.

    3. In the Operator field, select = Equals if it is not already selected.

    4. In the field to the right of the operator button, type

    5. Select the Is Case Sensitive checkbox if it is not already selected.

    6. Click image9 Styles.

    7. Click Custom Style.
      The Custom Style Properties window opens.

    8. In the Font Color field, change the font color to blue. You can do this by typing 0, 0, 255 in the field or by following these steps:

      1. Click the arrow in the Font Color field.
        A drop-down menu opens.

      2. Click the Web tab.

      3. Select Blue.

    9. In the Fill field, change the fill color to white. You can do this by typing 255, 255, 255 in the field or by following these steps:

      1. Click the arrow in the Fill field.
        A drop-down menu opens.

      2. Click the Web tab.

      3. Select White.

    10. Click OK.
      The Custom Style Properties window closes.

  11. In the Apply field, select Any if it is not already selected. This ensures that if the Status column value is , the cell style will change.

    image14

  12. Click OK on the Add Condition/Appearance Mappings window.
    The statuses in the Status column display in the selected colors.

  13. Save the grid layout.