Dan,

In cell A5, use this formula

=IF(A4+7=TODAY(),A4+7,"")


For the formatting, select the cells in column B (with the active cell being the first of your
Dan,Betty & Ray cells) and use Format / Conditional Formatting "Formula is " option, with a
formula like this

=MOD(ROWS($A$1:A1),10)=0

and set the font and fill as desired.

HTH,
Bernie
MS Excel MVP


"Danny Boy" wrote in message
...
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