View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
sungen99[_81_] sungen99[_81_] is offline
external usenet poster
 
Posts: 1
Default Refreshing of =now() not producing what I need


It does not seem to work. I have cell G3 have how long before the clos
you want to the color to change to red. If I make it 00:10:00 its no
giving me 10 minutes, its giving me 12:10:00 AM how do I change this

--
sungen9
-----------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...nfo&userid=914
View this thread: http://www.excelforum.com/showthread.php?threadid=52611