+ Reply to Thread
Results 1 to 2 of 2

Remove Conditional Formatting from Specific Cells

  1. #1
    Forum Contributor
    Join Date
    03-26-2015
    Location
    Cookeville, TN
    MS-Off Ver
    Excel 365
    Posts
    202

    Remove Conditional Formatting from Specific Cells

    This should be simple (I would think), but not sure how to do it. If I have a single conditional format that's applied to multiple cells, how can I use VBA to remove that conditional format for JUST ONE (or maybe a few) of those cells?
    The cell(s) to be changed is variable (I'll call it MyRange). I need code that handles this for any current AppliesTo range for the conditional format.
    I know I could use:
    Please Login or Register  to view this content.
    but does that simply remove the conditional format from MyRange (leaving it intact for any remaining cells), or does it completely delete that conditional format from ALL of its cells (which is NOT what I want)?

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Remove Conditional Formatting from Specific Cells

    MyRange.FormatConditions.Delete would delete all conditional formatting from ONLY the cells that MyRange covers.
    All other cells would remain unaffected.

    BSB

+ 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] conditional formatting of specific cells based on 1 cell value
    By RachelMads02 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-29-2017, 03:38 PM
  2. [SOLVED] Conditional Formatting - Highlighting specific cells
    By jlo33 in forum Excel General
    Replies: 4
    Last Post: 06-07-2013, 04:50 PM
  3. Conditional Formatting for Specific Cells
    By amoto in forum Excel General
    Replies: 7
    Last Post: 04-13-2013, 11:59 AM
  4. Replies: 3
    Last Post: 03-26-2012, 11:18 AM
  5. Using Conditional Formatting to Shade Specific Cells
    By Hypnopoison in forum Excel General
    Replies: 4
    Last Post: 04-03-2011, 11:45 AM
  6. [SOLVED] conditional formatting on specific text in cells
    By kwkhoo in forum Excel General
    Replies: 3
    Last Post: 06-21-2005, 12:05 PM
  7. Replies: 3
    Last Post: 04-27-2005, 06:57 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