+ Reply to Thread
Results 1 to 2 of 2

Using Conditional Formatting to Highlight Cells When Date/Time is 12 & 18 Hours Later

  1. #1
    Registered User
    Join Date
    01-18-2012
    Location
    Lancaster, PA
    MS-Off Ver
    Excel 2020
    Posts
    3

    Using Conditional Formatting to Highlight Cells When Date/Time is 12 & 18 Hours Later

    I have a spreadsheet where I have a column with a date and time that a client has approved a project. I would like to do a conditional format where the cell turns yellow when the current date/time is 12 hours past the approval date, then red when the date/time is 18 hours past the approval date. Is this something that I can do using the NOW() function? I would like to avoid adding columns if possible.

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,062

    Re: Using Conditional Formatting to Highlight Cells When Date/Time is 12 & 18 Hours Later

    Conditional Formatting
    2 Rules

    Rule 1
    =(A1<NOW()-TIME(12,0,0))
    format as yellow

    Rule 2
    =(A1<NOW()-TIME(18,0,0))
    format as red

    Either make sure Stop if True is not ticked
    or swap the rules and formatting around and tick the Stop If True box
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1