Ron doesn't do VBA, and I usually don't do formulas.
See the attached sample file for a VBA implementation for two predefined sample ranges. This implements borders, border color, and cell color only. For font attributes, either additional items must be predefined, or a MASTER cell must exist that contains the desired attributes. The MASTER cell can be hidden using custom formatting using 3 semi-colons and no brackets [;;;].
The following code goes in the Sheet module for the sheet that contains the data such as Sheet1:
Lewis
Bookmarks