Formatting sheets with macro running very slowly

Getting rid of all the Select/Selection in the code might speed things up a bit.

However, I think the main bottleneck is the two loops.

Not sure what you can do about them.

Hi nickmax1,
Try to avoid interactive command like ".Select"
for example instead of

Please Login or Register  to view this content.

use

Please Login or Register  to view this content.

Try this and if you still have problem let us know

The macrorecorder is not that smart. Apart from using Select all the time it also records all properties even though just one or two has been changed.
Since you start by clearing the format on the whole range you can delete all the formatting commands that just sets the values to their defaults.

The first bunch of lines looking like this:

Please Login or Register  to view this content.

could be changed into something like this:

Please Login or Register  to view this content.

Note also the dim x statement. That tells VBA that I'm gonna use a variable named x and that it will contain a range. This saves a little bit of memory and speeds things up just a little bit.
I haven't tested this code and I may have deleted some rows that were not the defaults but hopefully it will give you some leads anyway.