+ Reply to Thread
Results 1 to 2 of 2

Copying a range of cells that are conditionally formatted from one worksheet to another

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    Stafford
    MS-Off Ver
    2007
    Posts
    1

    Smile Copying a range of cells that are conditionally formatted from one worksheet to another

    I have a worksheet (A) containing a row of cells some of which contain data and some of which are blank. This row is conditionally formatted to colour fill the cells if they contain data.
    I have another worksheet (B) which has an empty row of cells again conditionally formatted so that if they contain data they will colour fill. These cells are also custom formatted to ;;; so that it will hide any data that is input to the cell and leaving only the colour fill visible.

    I want the data from the row in worksheet (A) to automatically be fed through to the row in worksheet (B). I have tried treating it as a named range and pulling it through but any blank cells in (A) are pulled through as 0 into (B) and therefore the cell fills with colour in sheet (B) when I wish it to remain uncoloured.

    Please can someone advise how to resolve this.

    Thank you

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Copying a range of cells that are conditionally formatted from one worksheet to anothe

    Hi NoviceDeb,

    welcome to the forum.

    Can you share a sample workbook ? thx


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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