Use VBA to set Border of a range

[woah]

Hi there,

I would like to a add border to every cell in the below range. The range (Column A7:F) sometimes contain more or less data. I would like to automatically add border to all the cells. However, as Column B ("Time") not necessarily will always have data, I might want to use Column D "Name" as a reference. I would like to add border up to the row that have data.

Please kindly advise. Thank you.

 

[woah]

I try to use conditional formatting. However, I don't know how to set up a formula to border Column B when Column D has data. Please kindly advise. Thank you