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

Try something similar to this in conditional formatting - Formula is, with
A1 active:

Condition1
=TODAY()-A190

Condition2
=AND(TODAY()-A1<91,TODAY()-A10)

Condition3
=TODAY()-A1<1

--
Damon Longworth

2006 East Coast Excel User Conference
April 19/21st, 2006
Holiday Inn, Boardwalk
Atlantic City, New Jersey
Early Bird Registration Now Open!!
www.ExcelUserConference.com

2006 UK Excel User Conference
Summer, 2006
London, England
"c_shema" wrote in
message ...

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