+ Reply to Thread
Results 1 to 2 of 2

Copy or link formating from conditionally formated cell to another cell

  1. #1
    Registered User
    Join Date
    07-08-2014
    Location
    San Diego, CA
    MS-Off Ver
    2010
    Posts
    1

    Copy or link formating from conditionally formated cell to another cell

    I have been digging through a large number of conditional formatting threads and have yet to find this specific instance. I have a column who’s content is determined via about 6 nested if statements from data on that row. That cell is then conditionally formatted to a certain color based on the text that is ultimately printed from the nested ifs (simply an extra visual legend for the text). All of this contributing info and about 1000 lines items make a very large and difficult to print page. What I am trying to do is a make a summary sheet that simply takes the index number of these 1000 rows and copies or links the conditional formatting of the mentioned cell onto this number on another sheet. I have already linked this status cell and put it adjacent to the index number which works well in that with two columns I can show the index and status but if I could combine the color of the status cell onto the index cell, it would be even better. I am pretty sure another conditional format for this summary sheet would not be possible or be extremely complex since the contents of the index cell I am conditionally formatting have no bearing on the conditions for the format. Was hoping there is some VBA magic that could simply mimic the conditional formatting from one cell and put it on another.

    A little complex and probably not the best description but I could upload a subset of the file if anyone is willing to dig into this.

    Thanks.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Copy or link formating from conditionally formated cell to another cell

    You'd have to use the same cf on this new cell as the cf on the source cell.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. conditionally copy/link a row to a sheet
    By avib in forum Excel General
    Replies: 1
    Last Post: 07-17-2014, 02:21 AM
  2. Struggling To Sum Conditionally Formated Cells With VBA
    By Limitedtimeonearth in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-11-2013, 06:17 PM
  3. How to copy conditionally formated cells?
    By John K in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-11-2008, 05:10 PM
  4. Copy results of conditionally formated values
    By kiwipost in forum Excel General
    Replies: 2
    Last Post: 04-23-2008, 04:04 AM
  5. [SOLVED] Copying a format that has been conditionally formated
    By taloma715 in forum Excel General
    Replies: 1
    Last Post: 01-14-2006, 11:10 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