Hi, first time posting here...I am trying to make a cell (A1) with a
date in it turn red within say 15 days, and then turn back to the
original color when the completion date in cell B1 is inserted.
Basically I'm making a training spreadsheet that will show training
coming due (with alerts...red color) and training complete dates. I
have pretty much figured out how to make A1 turn red within 15 days,
but I cannot figure out how to change it back to the original color
dependent on cell B1. Any help would be appreciated!!

Scott


--
tufftoy
------------------------------------------------------------------------
tufftoy's Profile: http://www.excelforum.com/member.php...o&userid=36567
View this thread: http://www.excelforum.com/showthread...hreadid=563137