Results 1 to 9 of 9

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

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2017
    Location
    Midwest
    MS-Off Ver
    Office 365
    Posts
    32

    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
    Attached Files Attached Files
    Last edited by s2h; 10-19-2017 at 11:42 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Excel Macro: Bold Entire Row if Cell Contains the word Total
    By arnel_10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-11-2017, 10:09 PM
  2. [SOLVED] When clicking cell within range, make it bold. If already bold, make it not bold
    By jokris in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2016, 07:12 PM
  3. Lop to Bold Entire Row if cell contains text
    By xfortunax in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 10-23-2015, 03:05 PM
  4. Macro seems to make entire text string in cells Bold
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2014, 01:30 PM
  5. Macro to removed entire row on Sheet A if a text matches a condition on Sheet B
    By andy@2ggroup.ca in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-03-2012, 04:22 PM
  6. How to make some text in a Cell Bold?
    By v2jtb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2012, 11:00 AM
  7. Need to make certain text bold in a comment using vba
    By Bravurian17 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2009, 11:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1