This is probably a noob question, but what I want to do is to have a
cell that has a range of different times. If that time is greater than
10, I want another cell to have its background color red, otherwise
it's green (<10). I want it to be constantly checking so that I dont
have run the macro everytime I update something for it to change. A
little help on this would be greatly appreciated!

Thanks!


--
McManCSU
------------------------------------------------------------------------
McManCSU's Profile: http://www.excelforum.com/member.php...o&userid=24379
View this thread: http://www.excelforum.com/showthread...hreadid=388004