## Tom’s Tutorials For Excel: Calculating Negative Time

Tom’s Tutorials For Excel: Calculating Negative Time

Here’s an example for calculating the difference between times, and expressing a negative result when a larger time is subtracted from a smaller time.

In the picture, runners are listed for comparing their 1000 meter run times against the record time.

## Tom’s Tutorials For Excel: Conditional Formatting the Nth Highest and Lowest Items in a List

Tom’s Tutorials For Excel: Conditional Formatting the Nth Highest and Lowest Items in a List

When you want to highlight more than just the single lowest (minimum) or single highest (maximum) value in a list, here’s how.

In the above picture,

## Tom’s Tutorials For Excel: Comparing Two Lists and Formatting Differences

Tom’s Tutorials For Excel: Comparing Two Lists and Formatting Differences

Here’s how you can format differences in a long list when comparing it to a shorter list.

In the picture, column A holds a comprehensive list of names, and column B contains a shorter list where some names are found in column A (colored green),

## Tom’s Tutorials for Excel: Dynamic Conditional Formatting By Group

Tom’s Tutorials for Excel: Dynamic Conditional Formatting By Group

To improve the readability of your lists, you can conditionally format alternating groups of primary items. The challenge is to make this happen when the count of each client name varies in the list, which can change at any time.