Results 1 to 8 of 8

VBA to Modify Conditional Formatting Text

Threaded View

  1. 05-27-2018, 09:19 AM #1
    ker9
    ker9 is offline
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2010
    Posts
    278

    VBA to Modify Conditional Formatting Text

    Hi,
    Is it possible to use VBA to modify conditional format text? For example, if the text is "xxx" change it to "yyy". This is the text value that triggers the conditional format. (Highlight Cells with Text that contains...) Any/all ranges on the sheet where it occurs.
    Thank you.
    Last edited by ker9; 05-27-2018 at 09:25 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can you modify the range (using a Sub) for an existing conditional formatting rule?
    By sam.schardt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-04-2016, 02:44 PM
  2. [SOLVED] How to modify conditional formatting to ignore specific values
    By GIS2013 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-13-2015, 07:44 AM
  3. Formatting Cells with Date or Text Values in a Conditional Formatting Formula
    By Phil Hageman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-15-2014, 09:36 AM
  4. How to retrieve/modify/disable/enable conditional formatting rules in VBA
    By hershmab in forum Excel General
    Replies: 0
    Last Post: 03-13-2013, 12:05 PM
  5. Modify Conditional Formatting
    By jamie.c in forum Excel General
    Replies: 15
    Last Post: 07-24-2009, 04:45 AM
  6. Modify a conditional formatting macro
    By dcgrove in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-29-2009, 04:50 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1