TMW Back Office
  • TMW Back Office
  • Layouts - Data grids
  • Applying conditional formatting
  • Examples of conditional formatting

TMW Back Office

    • Introduction to TMW Back Office
      • Logging in and out
      • Viewing system details
  • TMW Back Office directories
    • Video directory
  • Quick Start guides
    • Quick Start: How do I process an invoice?
    • Quick Start: How do I process pay for a trip?
    • Quick Start: How do I finalize pay for a resource?
  • Release notes
    • Release note introduction
    • What’s new in 2023.3
    • 2023
      • 2023.2
      • 2023.1
    • 2022
      • 2022.4
      • 2022.3
      • 2022.2
      • 2022.1.13.192 Service Pack
      • 2022.1
    • 2021
      • 2021.4.26.202 Service Pack
      • 2021.4.15.16 Service Pack
      • 2021.4
      • 2021.3
      • 2021.2
      • 2021.1
    • 2020
      • 2020.4
      • 2020.3
      • 2020.2
      • 2020.1
    • 2019
      • 2019.4
      • 2019.3
      • 2019.2
      • 2019.1
    • 2018
  • Navigation and data entry
    • Understanding basic window features
    • Choosing a window layout
    • Navigating within the application
    • Basic data entry
      • Using keyboard shortcuts
      • Accessing the mileage windows
  • Data grids
    • Using data grids
      • Filtering data in a grid
      • Adding multiple filters to a grid
      • Working with columns
      • Grouping data in a grid
      • Copying column contents
      • Exporting data
      • Printing data
      • Saving or deleting a data grid layout
  • General system setup
    • Using the label file to customize fields
    • Applying security to grid/table rows
      • System setup
      • Defining a table’s security
      • Assigning security to a user or group
      • Enforcing security setup
      • Restricting access to field options
    • Encrypting Social Security numbers
    • Setting up unit conversions
    • Setting up currency conversions
    • Setting up your system for invoicing
      • Setting up charge types
      • Assigning invoice and master bill formats
      • Configuring invoice outputs
      • Setting up e-mail distribution for invoices
      • Setting up master bills
    • Setting up your system for settlements
      • Setting up pay types
      • Setting up pay schedules
      • Setting up guaranteed pay
      • Assigning settlement sheet formats
      • Setting up e-mail distribution for settlement sheets
    • Setting up a holiday schedule
    • Setting up Trimble Places
    • Setting up the TMW No-Touch Processor
    • Setting up the Microsoft Dynamics GP Interface
      • Preliminary setup in TMWSuite
      • Working with company profiles
      • Setting up multi-currency features
  • Tracking paperwork
    • Introduction to paperwork tracking
    • Setting up paperwork tracking
    • Checking in paperwork in Invoicing
    • Checking in paperwork in Settlements
    • Using paperwork status as a queue restriction
  • Invoicing
    • Introduction to the Edit Invoice Folder
    • Looking up orders and invoices
    • Processing a single order or invoice
      • Creating credit memos and rebills
      • Creating a split bill
      • Deleting invoice data
      • Creating additional or stand-alone invoices
    • Processing multiple orders and invoices
    • Processing accrual rebates
    • Master bills
  • Trip Settlements
    • Introduction to the Trip Settlements Folder
    • Processing pay for a single trip
    • Processing pay for multiple trips
    • Correcting pay
  • Time Settlements
    • Introduction to the Time Settlements Folder
    • Processing hourly pay for a resource
  • Final Settlements
    • Introduction to the Final Settlements Folder
    • Finalizing pay for a single asset
    • Finalizing pay for multiple assets
    • Printing settlement sheets
  • Inbound EDI 210 invoices
    • Processing Inbound EDI 210 invoices for carriers
  • Recurring adjustments
    • Overview of recurring adjustments
    • Setting up a pay type for a recurring adjustment
    • Setting up recurring adjustments
      • Recurring deductions
      • Recurring pay adjustments
      • Per diem adjustments
      • Recurring escrow adjustments
      • Recurring loan adjustments
    • Assigning recurring adjustments to an individual resource
    • Assigning recurring adjustments to a group of resources
    • Deleting or changing the status of a recurring adjustment
  • Rating
    • Tariff Maintenance window
    • Creating a billing rate
    • Billing rate examples
      • Generating accrual rebates
      • Calculating detention charges automatically
    • Creating a pay rate
    • Pay rate examples
      • Setting up holiday pay
      • Setting up a Premium Day rate table for holiday pay
      • Setting up an Additional Earnings pay rate
      • Calculating detention pay automatically
    • Working with rate tables
    • Setting up rate keys
  • Engage.Bid Import
    • The Engage.Bid Import feature
  • Notes
    • Introduction to the Notes feature
    • Setup for the Notes feature
    • Adding, changing, and deleting notes
    • Using the pop-up notes feature
    • Copying profile notes to orders
  • Profiles
    • Driver profiles
      • Driver Profiles window overview
        • Header information
        • Information tab
        • Driver Management tab
      • Creating driver profiles
    • Company profiles
      • Using Trimble Places
      • Viewing average facility dwell times
  • Driver retention
    • Introduction to the Driver Retention feature
  • Scroll records
    • Using scroll windows to look up records
    • General setup for scroll windows
      • Preventing users from exporting scroll data to Microsoft Excel
    • Branches
    • Carriers
    • Commodities
    • Companies
    • Drivers
    • Empty Moves
    • Expirations
    • Invoices
    • Orders
    • Passengers
    • Pay To
    • Reference Numbers
    • Stops
    • Third Party
    • Tractors
    • Trailers
    • Truck Stops
  • Layouts - Overview
    • Using layouts to add security and control user actions
  • Layouts - Menus and toolbars
    • Changing menus and toolbars
    • Customizing menus
    • Customizing toolbars
    • Saving and deleting menus and toolbars
  • Layouts - Windows
    • Changing a window layout
      • Basing a new layout on the factory default
      • Adding and removing fields
      • Applying security to fields
      • Using rules to restrict field values
      • Changing a field’s look or position
      • Controlling the tabbing sequence
      • Customizing detail tabs
    • Adding links, reports, and custom grids to a window
      • Adding hyperlinks and embedded webpages
      • Adding reports and embedded report viewers
      • Adding custom grids
      • Using parameters
    • Saving, loading, and resetting a window layout
    • Copying layouts from one database to another
  • Layouts - Data grids
    • Changing a data grid layout
    • Applying conditional formatting
      • Examples of conditional formatting
        • Highlighting specific entries in a column
        • Color-coding dispatch statuses
    • Applying conditional editing
    • Summarizing data in grids
    • Fixing views to include required columns
  • Layouts - Assigning layouts to users
    • Assigning window and grid layouts
  • Frequently used features
    • Determining point-to-point mileage
  • Configuration settings
    • INI settings that are used by TMW Back Office
    • General Info Table settings that are used by TMW Back Office

Examples of conditional formatting

The following examples provide some ways that you can use conditional formatting to enhance the appearance of data grids. You can also use formatting to call attention to data that meets specific criteria.

  • Highlighting specific entries in a column

  • Color-coding dispatch statuses

Contents