Please help me out, Ive been going nuts for 3 months how to get this
done right. Ive got a spreadsheet with employees listed in column A &
columns B, C. & D all have dates of various physicals (ie 08/01/06),
etc. How can I conditionally format these cells to turn a color 30
days prior to the yearly renewal dates (ie 08/01/07).


--
ljb15
------------------------------------------------------------------------
ljb15's Profile: http://www.excelforum.com/member.php...o&userid=37037
View this thread: http://www.excelforum.com/showthread...hreadid=553568