thought you might be interested, the conditional formatting I use for 3
different colors a (A4: x or y, are over-rides; a5 6 7 are x days out: 30
20 10..; purple, lite purple, yellow; lime green for column fades date to
back ground if ok)


=IF(OR(A9="",$A$4="x"),"",(TODAY()+1)(A9+A$5))
=IF(OR(A9="",$A$4="x"),"",(TODAY()+1)(A9+A$6))
=IF(OR(AND(J9="",AT9=""),$A$4="x",$A$4="z"),"",OR( A9="",(TODAY()+1)(A9+A$7)))

"sigfreund" wrote:


Can I have the time entered into cell a1 automatically by entering a
value into b1 or c1, if so how can I have this continue down the entire
colum. I am stuck in a hospital bed and need to figure out an easy way
to track some fluid ins and outs and keep a running total. Thanks


--
sigfreund
------------------------------------------------------------------------
sigfreund's Profile: http://www.excelforum.com/member.php...o&userid=32096
View this thread: http://www.excelforum.com/showthread...hreadid=518500