+ Reply to Thread
Results 1 to 5 of 5

copy conditional formats

Hybrid View

  1. #1
    Registered User
    Join Date
    04-21-2004
    Posts
    28

    copy conditional formats

    Hi,
    I have a cell with seven conditional formatting formula rules that I now want to copy to the rest of the column. I can copy/paste special/formats one cell at a time but if I try to to this with a group of cells, (or try using the format painter), it treats the formula references as absolute, even though they aren't shown as absolute in the rules manager. Am I missing something? Using 2007.
    Last edited by by1612; 03-30-2009 at 05:12 PM.

  2. #2
    Registered User
    Join Date
    03-27-2009
    Location
    China
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: copy conditional formats

    Can you upload the file or advise the formula you're using in the conditional formatting?

  3. #3
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: copy conditional formats

    Why don't you just select the cell with the formatting, select "manage rules" and then extend the selection of cells that these rules apply to.

  4. #4
    Forum Contributor mubashir aziz's Avatar
    Join Date
    03-18-2009
    Location
    Lahore, Pakistan
    MS-Off Ver
    MS Office 2013
    Posts
    533

    Re: copy conditional formats

    Just Select the First Cell of The column then by pressing Shift Key Select the Last column and apply the C. Formatting ...

  5. #5
    Registered User
    Join Date
    04-21-2004
    Posts
    28

    Re: copy conditional formats

    Thanks everyone. Suggestions taken. Problem solved.

+ 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