+ Reply to Thread
Results 1 to 4 of 4

Carrying Conditionally Formatted Cell to New Sheet

  1. #1
    Registered User
    Join Date
    03-24-2015
    Location
    Orlando, Florida
    MS-Off Ver
    2013
    Posts
    12

    Carrying Conditionally Formatted Cell to New Sheet

    Good evening everyone,

    Here is the scenario I face while utilizing the conditional formatting tool:

    In sheet 1 I have a column of values whose font color is adjusted based on 4 conditions. In sheet 2 I have rearranged this column of values into a chart to present my data. I assumed the font color of the values in Sheet 1 would carry over, but I soon discovered this is not the case. I could apply the conditional format tool to my cells in Sheet 2 to tie back to the original condition I created in Sheet 1. However, the table in Sheet 2 needed to be arranged in a way that this will take forever to accomplish and leave much room for mistakes when creating the countless formulas.

    Would anyone have any advice on how I could format my results in Sheet 2 to keep the colored font created for the values in Sheet 1?

  2. #2
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Carrying Conditionally Formatted Cell to New Sheet

    Copy (Tab 1)
    On Tab 2 > Paste Special > Formats

  3. #3
    Registered User
    Join Date
    03-24-2015
    Location
    Orlando, Florida
    MS-Off Ver
    2013
    Posts
    12

    Re: Carrying Conditionally Formatted Cell to New Sheet

    Even using paste special format it still wont carry over the font color. Is there perhaps something I need to alter with the rule I applied to the conditional formatting for my values in Sheet 1 to allow this paste special to work?

  4. #4
    Registered User
    Join Date
    12-12-2014
    Location
    PL
    MS-Off Ver
    2010
    Posts
    55

    Re: Carrying Conditionally Formatted Cell to New Sheet

    This cannot be achieved based on the cell color added by CF, you need to add the same rules as on the first sheet. Might help if you posted the workbook, maybe we can figure out a way to get this done quickly.

+ 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 reference a conditionally formatted cell(s)
    By EXCELNEWCOMER in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-22-2013, 04:34 AM
  2. Need a macro to delete row based on conditionally formatted cell
    By twinklestar922 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2013, 06:47 AM
  3. how to copy a cell that has been conditionally formatted
    By Dexter Stagg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-27-2012, 05:03 PM
  4. How to count cell which are conditionally formatted?
    By parekhharsh_j in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-12-2011, 02:53 PM
  5. Reading a conditionally formatted cell
    By akronpow in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-03-2007, 03:57 PM

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