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 Name quickly in the Driver tab of the Planning Worksheet’s Available Resources grid. You create an expression that will display that driver’s name in bold font when it equals the Driver ID you specify.

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

TMW Operations prior to version 17.10

  1. Retrieve data in the Available Resources grid of the Planning Worksheet.

  2. Click the Driver resource tab.

    image1

  3. Right-click the DriverName column header.

  4. From the shortcut menu, select Conditional Format.
    The Add Condition/Appearance Mappings window opens.

  5. Click Add Formula Condition.

    image2

    The Formula Builder window opens.

  6. On the Operands tab, go to the appropriate control.

    For this example, expand Controls > DisplayOnlyGrid1 > WrapperDriver.

  7. 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 DriverName column is disabled.

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

      image3

  8. Click the appropriate operator button.

    image4

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

    image5

  9. 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.

    image6

  10. Click OK.
    The Formula Builder window closes.

  11. In the property grid, locate and expand the FontData property.

  12. On the same line as Bold, select True.

    image7

  13. Click OK.
    The driver’s name you specified appears in bold font.

    image8

  14. Save the grid layout.

TMW Operations version 17.10 and later

  1. In the Planning Worksheet, retrieve data in the Available Resources grid.

  2. Click the Driver resource tab.

    image1

  3. Right-click the DriverName 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 Formula.

    image9

  6. Click image10 Formula Builder.
    The Formula Builder window opens.

  7. On the Operands tab, go to the appropriate control.

    For this example, expand Controls > DisplayOnlyGrid1 > WrapperDriver.

  8. 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 DriverName column is disabled.

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

      image11

  9. Click the appropriate operator button.

    image12

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

    image13

  10. 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.

    image14

  11. Click OK.
    The Formula Builder window closes.

  12. Click image15 Styles.

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

  14. In the Style section, select image16 Bold.

  15. 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.

  16. 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.

      image17

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

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

    image18

  19. Save the grid layout.