How to Make Time Cell , Highlighted!!!

  • Thread starter Thread starter Pivotrend
  • Start date Start date
P

Pivotrend

hello

i have a news Cell that update every 60 sec
in Cell A1 is the Current Time =NOW()

in Cell A2 is the time of that Breaking news , B2 is the Breaking news

is it possible to make A2 lighlighted with Different Color or Font if
it's Not Less than current time in Cell A1 of 5 Minutes ?
 
If I'm understanding you, you want to change the color
of A2 if it's less than 5 minutes behind the current time
in A1?

Try

Select cell A2

Menu->Format\conditional formatting

Select "Cell Value is"
Select "less than"
Enter in 3rd box "=$A$1 + 0.00347222"
Choose your format color.

the .00347222 adds 5 minutes to the time in a1
you can play with this - make it "greater than",
and use multiples of .002347222.

Hope this helps. Should be close.
jeff
 
Select A2 and do Format / Conditional Formatting, change 'Cell Value is' to
'Formula is' and put in =A2<(A1-(1/(24*60))*5)

Now choose a font or pattern colour to suit.
 
didn't work

this one worked but not 5 minutes , all times
Select "Cell Value is"
Select "less than"
Enter in 3rd box "=$A$1 + 0.00347222"


!!
 
didn't work

Worked for me
Enter in 3rd box "=$A$1 + 0.00347222"
Click to expand...

Should be a minus not a plus. Whatever is in cell A2 is ALWAYS going to be less
than or equal to NOW(), so it will definitely be less than or equal to NOW()+5
min, which is why it will always stay formatted.
 
Back
Top