Iterate through, Format Cells in VBA

[msaluta]

I have an automated report that generates a table of values that need to be iterated through and saved to a different format.
Here is the table:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">John Smith 5/26/2018 12345 IT Pro John Gault Permitting Sarasota
Winston Smith 5/30/2018 54321 Henchman Bob Licensing Oceania</code>The format that I'm looking to get that information to is the following:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">Name: John Smith
Date Starting: 5/26/2018
Employee ID#: 12345
Title: IT PRO
Supervisor: John Gault
Bus Ctr: Permitting
Location: Oceania

Name: Winston Smith
Date Starting: 5/30/2018
Employee ID#: 54321
Title: Henchman
Supervisor: Bob
Bus Ctr: Licensing
Location: Oceania</code>The amount of employees on the report will change on a given day, so I believe a For Each is in order, something to the effect of:
<code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: Consolas, Menlo, Monaco, "Lucida Console", "Liberation Mono", "DejaVu Sans Mono", "Bitstream Vera Sans Mono", "Courier New", monospace, sans-serif; vertical-align: baseline; box-sizing: inherit; white-space: inherit;">For Each Cell In ActiveSheet.UsedRange.Cells</code>I'm just uncertain what to put into the For loop.

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1057647-iterate-through-format-cells-vba.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

Note that sometimes posts from new users require Moderator approval before you can see them on the public forums. When this happens, you should see a message to that effect when you try to post it.
Please be patient and do not attempt to post the question again.