Automatically highlight certain data.

[wiersma7]

I have a spreadsheet with a schedule of duties that are done every Sunday.
Different people are assigned each week for each duty.
For instance:
Sunday, May 2
Greeters Mr. x
Ushers Mrs. y
Counters Ms. z

It's a vey long list and a very large spreadsheet (covers several years of
Sundays)

I'd like to be able to highlight/change letter color for the Sunday list
that has the info for the upcoming Sunday. I've been trying to figure it
with 'Conditional Formatting' but there must be a calculation, or something,
to figure out how to know which week. I tried the 'next week' option but I'm
not getting any changes.

Is there something I'm missing? of is there a way to calculate this?

Gobs of thanks in advance,
wiersma7

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.