need help with a macro to make certain text within the entire sheet BOLD

I need a better example of 6 sheets etc.

You could try to put this macro behind each pivot sheet. You will also need to have a sheet called BoldList in the workbook.

Putting it in each sheet seems to work well....

if I wanted to have it also add a color to it... like red for example
what do I need to add to it??
Font style????? do I need to add the Hex Color Code??
Whats VBA Method for adding color to the text?

basically I want to make them Bold... and RED
or BOLD and Some other color

I dont need it to do different colors on the same page... I just need to make one of the pages Bold it to RED instead of default text color