Can a cell be changed on a certain date

[Lou825]

I have Excel 2003 and I want a cell to change colors when the date i put in
the cell is within six months of todays date. Is this possible?
if A1 has 12NOV08 and A2 has 12NOV09 how can I get A2 to change to red when
its six months from todays date

 

[Chris Bode via OfficeKB.com]

Please follow following steps
1.Set the cells A1 and A2 to display date format as:-
select the cell > right click > format cells > number tab >select date
from category list >select 03/14/01 from type list > click ok
2.Now select A2 and click format>conditional formatting from the toolbar
3.In the dialog box, select cell value is from the left drop down list
4.select between from the middle drop down list
5.enter =$A$1 in the box to the between drop down list
6. enter =DATE(YEAR(A1),MONTH(A1)+6,DAY(A1)) to the last box
7.click format button and choose your color
8. click ok

Now you are done!......



Chris

 

[David Biddulph]

As a matter of interest, Chris, why have you done step 1, changing the
format of the date display?
Wouldn't the CF work regardless of what the date format display is?

The only logic I can see in changing the date format would be to spot if it
doesn't change, which would then tell you that the date contained text,
rather than a date, but if that was your logic in trying the format change,
you'd probably need to tell the OP what to do with the text if that is what
your test found.