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
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
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.
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
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks