View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OZDOC OZDOC is offline
external usenet poster
 
Posts: 13
Default Conditional Formatting

could you not if you reading from a cell with the time to set the condition
put into that cell
= now() +5 and read from that ? the 5 could be a variable from another cell
if you wish

"changetires"
wrote in message
...

I have a condition but I want to add some minutes to the condition so
the cell will turn the color I want but how do I write say (add 5
minutes then turn red when greater than)

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile:
http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=565331