Just to add, that should preceed the condition that sets it to green.

--
Regards,
Tom Ogilvy

"sungen99" wrote in
message ...

I love how this is working. It's really nice.

One last request.

I have added conditional formatting to this now too. If the cell is =
to closed its orange, if its not = to closed its green. How would I
add if there is 10 minutes or less to make it red????

thanks

Im using this for the formula btw.


=IF(AND($A$1C6,$A$1<D6),D6-$A$1,"Closed")


--
sungen99
------------------------------------------------------------------------
sungen99's Profile:
http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=526117