VBA Noob:

I was reading another thread where you helped someone with this code.

Say date in A1 enter this in B1

=IF(A1=DATE(YEAR(A1),MONTH(TODAY()),DAY(TODAY())), "<<< Birthday today","")

Will display <<< Birthday today if true

for the conditional formating select col and enter

=A1=DATE(YEAR(A1),MONTH(TODAY()),DAY(TODAY()))

VBA Noob
I tried it and it works great but,

I would like to do the same thing only have all the birthdays highlight for the
current month and then copy all the highlighted names and birthdays to a list to be printed and posted on a bulletin board.

What changes would I need to make to the code to make this work?

Thanks
Charles