I have a spreadsheet which has "Wednesday" dates in Column A (e.g. May 27,
2009, June 3, 2009, etc), and Names in Column B (Dan, Betty, and Ray). I'm
currently using a formula which automatically generates the names into Column
B when I input data (a date) into Column A:

=IF(A4<"","Dan, Betty & Ray","")
=IF(A5<"","Dan, Betty & Ray","")

What I'd like to achieve is two things:

(a)automatic posting of the "Wednesday" date in column A at midnight on each
Wednesday (beginning with today's date of May 27, 2009).

(b) the 10th Wednesday generated would color both the date and names in BOLD
RED.

Thanks much for any help!

Dan