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

Hello Everybody
I'm looking for a way to take my pivot table created from a list of values
and to make certain items in the pivot table Bold with a Macro

the list changes Daily, and the placement of items changes with it

so it needs to be flexible as to size in rows to allow for more or less rows in the pivot table each day

I do not mind having to have another sheet with a predefined list on it if that is what it takes

but for example, in my sheet - in the "pivot outbound" tab
I have a couple of items Manually set to Bold
and I'd like to be able to run a Macro to do this task for me

it needs to be for every instance of those values in the entire sheet, not just cell "F6" every time

Thanks for your help
it will be greatly appreciated

Hi s2h,

See the attached that has a macro that will do what I think you want.

Please Login or Register  to view this content.

Bold Pivot Table bases on List.xlsm

You will need to add to the Bold List to include others descriptions that you want.
To fire the macro you will need to tab away from the Pivot Tab and then back to it.

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

Hi s2h,

Do this:
Turn Macro Record On and then select a cell and format the text as you want and then turn the Macro Record Off. Look at the code that is recorded in VBA. Pick the parts of the .Font that you want/need. Here is what I get when I do this:

Please Login or Register  to view this content.

You can learn a lot of VBA by simply recording a macro and see what VBA thinks you did.

Try this:

Please Login or Register  to view this content.

The RGB number for RED is 255. See:
http://access-excel.tips/excel-vba-color-code-list/