+ Reply to Thread
Results 1 to 4 of 4

Change cell color if time has not changed

  1. #1
    Registered User
    Join Date
    06-12-2020
    Location
    NY
    MS-Off Ver
    2010
    Posts
    2

    Change cell color if time has not changed

    Hi
    Can someone help me change a cell color if the time has not updated in 2 minutes. Cell Time stamp 12:58 example. Cell Date example 12 JUN 2020 thanks

  2. #2
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Change cell color if time has not changed

    Hi -

    You can use this conditional format formula:

    =(NOW()-$C$1)*24*60>2

    That formula compares the time in cell C1 to the current time. If you are just comparing to two static times in two different cells, replace NOW() with the other, later, cell address. Once you enter the formula, pick the color format you want to display.

    Hope that helps.
    ____________________________________________
    If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
    -Go to the top of the first post
    -Select Thread Tools
    -Select Mark thread as Solved

    If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.

  3. #3
    Registered User
    Join Date
    06-12-2020
    Location
    NY
    MS-Off Ver
    2010
    Posts
    2

    Re: Change cell color if time has not changed

    Hi thanks did not appear to work.

    Looking for TIM_ACT to change colors or produce a false is it has not changed in 2 minutes.


    Also Trying to compare these if they have not updated say in 2 minutes (2 minutes apart). Maybe in the next column

    TIM_ACT VALUE_DT1
    15:26 15:18:23
    15:26 15:19:13
    15:26 15:21:42
    15:26 15:21:42
    15:26 15:25:36

  4. #4
    Valued Forum Contributor loginjmor's Avatar
    Join Date
    01-31-2013
    Location
    Cedar Rapids, Iowa
    MS-Off Ver
    Excel 2013
    Posts
    1,073

    Re: Change cell color if time has not changed

    Hi -

    See the attached spreadsheet. I have copied your times into it and created the following conditional formatting rule which turns the cell blue if Column A minus Column B is greater than 2 minutes.

    =IF((A2-B2)*24*60>2,TRUE,FALSE)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA to Change the Font Color if the Cells Value has Changed
    By PandoraGirl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2019, 05:50 AM
  2. [SOLVED] How do I change a cell color when value in cell is changed?
    By artemus06 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-13-2017, 06:47 AM
  3. Change background color of cell when data has been changed
    By paperboy in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 09-13-2013, 05:00 AM
  4. Change cell fill when changed different color depending on the day
    By rev0jace in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-17-2012, 11:06 AM
  5. Change of text color when drop down box is changed
    By vba_life in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-15-2010, 04:37 PM
  6. Cell value is changed, the cells change the color
    By lsuersoy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-06-2010, 07:17 AM
  7. Macro to color bacground of the cell and log time if cells content changed
    By hunsnowboarder in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-22-2008, 03:22 PM

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