+ Reply to Thread
Results 1 to 4 of 4

Auto skip colored cells VBA but include conditionally formatted cells also

  1. #1
    Forum Contributor
    Join Date
    07-30-2014
    Location
    Mosman, Australia
    MS-Off Ver
    2013
    Posts
    118

    Auto skip colored cells VBA but include conditionally formatted cells also

    Hi,

    I have the below VBA which is greT but its not working with my conditional format cells. I'm using the formula based conditional format where if there is the letter "x" in a cell on another sheet then the same cell turns to the RGB grey color(as below) on the same cell in this sheet.

    Is there anyway to change the vba to also include conditionally formatted cells, i don't want to have to manually color the cells.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,931

    Re: Auto skip colored cells VBA but include conditionally formatted cells also

    Is this question simular to the one below?

    http://www.excelforum.com/excel-prog...ormatting.html
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Forum Contributor
    Join Date
    07-30-2014
    Location
    Mosman, Australia
    MS-Off Ver
    2013
    Posts
    118

    Re: Auto skip colored cells VBA but include conditionally formatted cells also

    Ha yes it is! My stupid internet screwed up and i thought it wasn't submitted.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,931

    Re: Auto skip colored cells VBA but include conditionally formatted cells also

    In that case would you mark the earlier question as solved?

+ 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] How to Sum cells that have been conditionally formatted
    By kbaz555 in forum Excel General
    Replies: 2
    Last Post: 08-25-2014, 12:24 PM
  2. [SOLVED] Consolidating / Extracting Conditionally Formatted (Colored) Cells - Excel 2003
    By superdesi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-07-2013, 12:48 PM
  3. Print only range of cells that include data, even if all cells formatted
    By liam_bettinson in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-30-2012, 09:41 AM
  4. Replies: 7
    Last Post: 01-28-2011, 10:07 AM
  5. Move colored formatted cells to another worksheet
    By Maddoktor in forum Excel General
    Replies: 1
    Last Post: 04-16-2005, 07:07 AM

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