Coding, Formula, or Conditional Formating?

D

Danny Boy

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top