+ Reply to Thread
Results 1 to 16 of 16

Copy & paste conditional formatting?

  1. #1
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    315

    Copy & paste conditional formatting?

    Is it possible to copy the conditional formatting from one cell to another without removing the contents of the cell?
    Last edited by Ltat42a; 10-01-2012 at 12:16 PM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy & paste conditional formatting?

    Yes it is.

    Which is the rule?

    Which are the ranges?
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Copy & paste conditional formatting?

    Select the Cell you want to copy from. Right click with your mouse > click on Copy> select destination Cell> Right Click on your mouse> Click on "Paste Special" > then Click on "Formats" > Click on O.K.

    You may have to edit the conditional format formulas to suit your requirements.
    Last edited by Winon; 10-01-2012 at 10:00 AM.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    315

    Re: Copy & paste conditional formatting?

    Quote Originally Posted by Fotis1991 View Post
    Yes it is.

    Which is the rule?

    Which are the ranges?
    A2 is =WORKDAY($C$1,D1)
    C1 is =today()
    D1 is 1

    Column A range is A2:A211

  5. #5
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy & paste conditional formatting?

    Do you also use range C2:C21 AND D2:D23 with data?

    Which is the rule in Conditional Formatting? =WORKDAY($C$1,D1)

    You mean something like this?

    =WORKDAY($C1,$D1)

  6. #6
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    315

    Re: Copy & paste conditional formatting?

    No, not using the C or D column (except C1 & D1).

    The conditional formatting I'm using is =IF(AND(A2=TODAY()),IF(B2<>"",TRUE,FALSE))

  7. #7
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy & paste conditional formatting?

    Why don't you just adjust the range in C.F rules to A2:A23?

    If_agai_)did not get it, pls, upload a small sample workbook.

  8. #8
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    315

    Re: Copy & paste conditional formatting?

    Quote Originally Posted by Fotis1991 View Post
    Why don't you just adjust the range in C.F rules to A2:A23?

    If_agai_)did not get it, pls, upload a small sample workbook.
    Huh? Not sure what you mean here.
    Attached Files Attached Files

  9. #9
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy & paste conditional formatting?

    Let's hope that i get it.

    iN b37 IN c.f RULES YOU HAVE ONE FORMULA. sAME FORMULA YOU WANT TO COPY TO ALL THE RANGE IN COLUMN b..

    Is this?
    Attached Files Attached Files

  10. #10
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,213

    Re: Copy & paste conditional formatting?

    another way is to copy/paste formats
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  11. #11
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Copy & paste conditional formatting?

    @ FDibbins,

    Hallo my vriend,

    another way is to copy/paste formats
    That is what I also said in Post No.3. I'll have a look at the WorkBook now.

    Bly in kontak!

  12. #12
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Copy & paste conditional formatting?

    Can you please add another sheet to the WorkBook, showing us what exactly how you want to achieve what?

    Column A & B seem to be doing what it should. How do you want to implement changes and where?

  13. #13
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Copy & paste conditional formatting?

    Check out the attached WorkBook, and you will see that as the date changes, and you enter a value in the appropriate Cell in Column B, the Cell in Column B changes to Yellow. A day later that very same cell will revert back to no interior color.
    Attached Files Attached Files

  14. #14
    Forum Contributor
    Join Date
    06-29-2005
    Location
    TN
    MS-Off Ver
    Office 365
    Posts
    315

    Re: Copy & paste conditional formatting?

    Got it, Thank you.

  15. #15
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,076

    Re: Copy & paste conditional formatting?

    Hi Ltat42a,

    You are welcome!

  16. #16
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Copy & paste conditional formatting?

    You are welcome!

    Thanks for the reb*

+ 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