Tom’s Tutorials For Excel: Conditionally Formatting Early, Late, and Acceptable Times

Tom’s Tutorials For Excel: Conditionally Formatting Early, Late, and Acceptable Times
Here is how you can use Conditional Formatting to identify times that are more than, or less than, a margin of acceptability. In the picture, the cells holding airline flight arrival times that occur more than 60 seconds earlier than their scheduled arrival time are shaded yellow. The Conditional Formatting formula in cell B12 copied down to cell B22 for the yellow cells is
=B12 < A12-(1/1440).
Cells holding an actual arrival time more than 1 minute later than their scheduled time are shaded blue. Their Conditional Formatting formula in cell B12 copied down to cell B22 for the blue cells is
=B12 > A12+(1/1440).
TTFE0008

Share Button
Posted in Tom's Tutorials for Excel
Tags: ,
2 comments on “Tom’s Tutorials For Excel: Conditionally Formatting Early, Late, and Acceptable Times
  1. Kali biswal says:

    this is not working

    • Tom Urtis says:

      Yes it is working and it does work as you can see by the picture. “This is not working” tells me and everyone reading this nothing useful about what exactly you are working with and what you are doing wrong.

Leave a Reply

Your email address will not be published. Required fields are marked *

*