Is there an easy way to add the active control option - "date and time picker control" to a column of cells say in range A3:A50, and link each individual date picker to the cell underneath.

It would also be helpful to control the font size and colurs to all the cells in any easy option.

I am familliar with adding a few active controls and choosing "linked Cell" but would like to apply to multiple drop downs to a large number of cells in a range

Thanks.
Junada0