VBA offers a powerful way to automate cell and worksheet formatting in Excel. Here's a breakdown of how you can achieve this:

Formatting Cells:

1. Target Cells: You can use various methods to specify the cells you want to format.
* Range Object: Use the `Range` object to define a specific range of cells (e.g., `Range("A1:B10")`).
* UsedRange: Use the `UsedRange` property to target the currently used range of cells.
* Selection: Use the `Selection` object to format the currently selected cells.
2. Formatting Properties: VBA exposes various properties to control cell formatting:
* Font.Bold/Italic/Size/Color: Set font properties for bold, italics, size, and color. (e.g., `Range("A1").Font.Bold = True`)
* Interior.Color: Set the background color of the cell. (e.g., `Range("B2").Interior.Color = vbYellow`)
* Borders: Set properties for individual cell borders (e.g., `.Borders(xlLeft).LineStyle = xlContinuous`) or format all borders at once. (e.g., `.Borders.Weight = xlThin`)
* NumberFormat: Apply specific number formats (e.g., currency, percentage). (e.g., `Range("C3").NumberFormat = "$0.00"`)
* Alignment: Set horizontal and vertical text alignment. (e.g., `Range("D4").HorizontalAlignment = xlCenter`)

Example - Formatting a Range:

```vba
Sub FormatCells()

' Define the range
Dim targetRange As Range
Set targetRange = Range("A1:C10")

' Apply formatting
targetRange.Font.Bold = True
targetRange.Interior.Color = vbLightBlue
targetRange.Borders.ColorIndex = xlAutomatic

End Sub
```

Formatting Worksheets:

1. Worksheet Object: Use the `Worksheets` collection to access a specific worksheet by name (e.g., `Worksheets("Sheet1")`).
2. Formatting Properties: Similar to cells, you can format aspects of the worksheet:
* PageSetup: Set margins, headers, footers, and other page layout options.
* GridLines: Control the display of gridlines.
* View: Set zoom level, freeze panes, and sheet visibility.

Example - Setting Page Margins:

```vba
Sub SetMargins()

' Access the worksheet
Dim worksheet As Worksheet
Set worksheet = Worksheets("Sheet2")

' Set margins (in inches)
With worksheet.PageSetup
.LeftMargin = 0.75
.RightMargin = 0.75
.TopMargin = 0.5
.BottomMargin = 0.5
End With

End Sub
```

Remember:

* You can combine cell and worksheet formatting within a single macro for complex automation.
* Explore the extensive VBA documentation for a complete list of formatting properties and methods.

By leveraging VBA, you can create macros to format your spreadsheets consistently and save time on repetitive tasks.