+ Reply to Thread
Results 1 to 3 of 3

Highlights specific text (not cells) with VBA

  1. #1
    Registered User
    Join Date
    09-27-2018
    Location
    lisbon
    MS-Off Ver
    2013
    Posts
    8

    Highlights specific text (not cells) with VBA

    Hello guys, I am facing the following issue: I need to highlight some key-words that appear in a column of my pivot table. What I am struggling the most is that I am not being able to write down code in VBA that enable to highlight in red several key-words and then to maintain these highlights when I filter the column (e.g. I highlight the word "http" but when I filter the column to appear just the rows that contain the word http in the column not all http words maintain the highlight and some other words highlight). Can someone help me?

    Thanks in advance.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello tmealha,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    09-27-2018
    Location
    lisbon
    MS-Off Ver
    2013
    Posts
    8

    Re: Highlights specific text (not cells) with VBA

    Thanks arlu

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] highlights cell based on text -- error -13
    By karurkumar in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2017, 08:05 AM
  2. [SOLVED] If a cell contains text insert specific text in specific cells in row
    By muss1210 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-18-2017, 10:51 AM
  3. [SOLVED] Counting cells with specific text excluding if date in specific cells
    By FraserMc97 in forum Excel General
    Replies: 2
    Last Post: 04-07-2017, 06:19 AM
  4. Copy text based on highlights
    By lparri in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-21-2016, 08:05 PM
  5. [SOLVED] Yellow highlights text summary
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-22-2015, 02:32 AM
  6. Need Macro that Highlights Values which Fall In Specific Range
    By Esuric in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2014, 03:27 AM
  7. Highlights Numbers (which are in text)
    By moody in forum Excel General
    Replies: 3
    Last Post: 02-20-2012, 06:40 AM

Tags for this Thread

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