Color Coding Cells

C

c_shema

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?
 
D

Damon Longworth

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

Condition1
=TODAY()-A1>90

Condition2
=AND(TODAY()-A1<91,TODAY()-A1>0)

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
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?
 
Top