I am trying to figure out how to color code each cell based upon the
date. If the date in the cell is 3 months or more away then it should
be green, if the date is within the 3 month period then it should be
yellow, if the date is today or later then it should be red. How do I
write a formula that will do this?


--
c_shema
------------------------------------------------------------------------
c_shema's Profile: http://www.excelforum.com/member.php...o&userid=31197
View this thread: http://www.excelforum.com/showthread...hreadid=508690