Highlighting specific entries in a column

Instead of formatting all the entries in a column the same way, as you would with a True condition, you might want to highlight only those entries that meet certain criteria. You can highlight specific column entries using a Formula condition, which formats one column based on criteria in another column.

This example illustrates how to spot a particular driver quickly in the LastName column of the Driver Scroll window. You create an expression that will display that driver’s name in bold when it equals the driver ID you specify.

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

  1. Go to Tools > Scrolls > Driver Scroll.
    The Driver Scroll window opens.

  2. Make sure the value in the View field is ScrollDriver.

    image1

  3. Retrieve data in the Driver Scroll window.

  4. Right-click the LastName column header.

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

  6. In the Select a condition type field, select Formula.

    image2

  7. Click image3 Formula Builder.
    The Formula Builder window opens.

  8. On the Operands tab, navigate to the appropriate control.
    For this example, expand Controls > _resultsGrid > Members.

  9. Locate and double-click the name of the column that contains the information on which you want to base the condition.
    Note: You cannot select the same data column you are formatting.

    For this example:

    • The mpp_lastname column is disabled.

    • Double-click mpp_ID, which contains the Driver ID.
      [mpp_ID] appears in the upper-right field.

    image4

  10. Click the appropriate operator button.

    image5

    In this example, click the = button. The equals sign is added to the expression.

    image6

  11. Within single quotation marks, enter the data item you want highlighted.

    If the entry is accepted, a message will appear in the lower-right field confirming that the formula compiled successfully.

    image7

  12. Click OK.
    The Formula Builder window closes.

  13. Click image8 Styles.

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

  15. In the Style section, select image9 Bold.

  16. In the Font Color field, change the font color to black if it is not already black. You can do this by typing 0, 0, 0 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 Black.

  17. In the Fill field, change the fill color to white if it is not already white. You can do this by typing 255, 255, 255 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.

    image10

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

  19. Click OK on the Add Condition/Appearance Mappings window.
    The driver’s name you specified appears in bold.

    image11

  20. Save the grid layout.