I hope I am posting this in the right section. I have programmed with Excel
macros and the visual basic editor, but it has been a while and I don't have
a good solid list of commands to use.

I have a spreadsheet in which I track certain events, some that need to be
completed annually, some semi-annually, and some quarterly. I would like to
set up a macro that would allow for the cells in each group to change color
as they approach the due date. Is this possible? I would like it to be sort
of a reminder to me that the event needs to be done if I haven't put a
"completed" date in the cell yet.

Let me give a more specific example--I have the sheet set up basically like
a list, with the events grouped by their due timeframe (ie. all quarterly
events are listed in rows). I have the cells all formatted already to accept
the date and when I complete a certain event, I put the date it was
completed. What I would like to do it format the cells in each grouping
(annual, semi-annual, quarterly) to change color if I open the sheet and the
event is not marked as completed and the due period is near. I know this
explanation does not seem clear as I read it, but hopefully you understand
what I'm asking. If I open the sheet on Feb.6 and the end of the quarter is
Feb. 13, I want the cell to change color to remind me that I need to complete
those events that need to be done by Feb. 13.
Can this even be done? I am looking at conditional formatting, but am not
sure what commands to use to tell it what I want it to do. And, if this
procedure is too deep for conditional formatting, I am wondering the commands
(arguments, etc.) to use to accomplish it in VB.
Thanks in advance!