+ Reply to Thread
Results 1 to 5 of 5

Excel 2007 : conditional formatting: Copy/Paste

  1. #1
    Registered User
    Join Date
    10-20-2010
    Location
    omaha, nebraska
    MS-Off Ver
    Excel 2007
    Posts
    22

    conditional formatting: Copy/Paste

    The title of this post may be a little misleading, but hear me out.

    I have a LOT of rules for my conditional formatting... and 12 "Sheets" (Jan-Dec)
    How do i copy/paste ALL the conditional formatting from "January" and paste it into "February-December"?

    OR

    How do i shorten this list of formatting rules? is there any way to combine any of them?

    1. =$N2="CSS" (Turns columns K and L green)
    2. =$N2="CSS Sigs" (Turns columns K and L green)
    3. =$N2="Rater" (Turns columns K and L green)
    4. =$N2="Rater Rater" (Turns columns K and L green)

    i know it seems redundant... but there are a lot of checkpoints for presentations we have, and once they hit a certian point, we still need them to show "good" (green)

    is there a way to combine those 4?
    Last edited by blizz; 04-07-2011 at 09:00 AM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: conditional formatting: Copy/Paste

    Maybe =(or($N2="css*",$N2="raster*)) ( in so far no other values contain those strings than the ones you want)

  3. #3
    Registered User
    Join Date
    10-20-2010
    Location
    omaha, nebraska
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: conditional formatting: Copy/Paste

    that doesn't seem to work.

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: conditional formatting: Copy/Paste

    Quote Originally Posted by blizz View Post
    that doesn't seem to work.

    Would you care to elaborate?

    Maybe adding a small sample sheet would help

  5. #5
    Registered User
    Join Date
    10-20-2010
    Location
    omaha, nebraska
    MS-Off Ver
    Excel 2007
    Posts
    22

    Re: conditional formatting: Copy/Paste

    sorry for the bland reply. I got it to work, but did them individually, as i could not figure out how to combine the rules. I was worried that with all my conditions, i'd have to type them all up on each sheet... I have approximately 20 conditions for formatting per sheet... and i have 12 sheets... that's a lot of copy/paste. Here's what i found:

    On sheet 1, do all of your conditional formatting (in my case, 20 rules).
    Then, select ALL cells that have been conditionally formatted.
    Ensure you are on the "Home" tab of the Ribbon.
    Just below the huge glowing circle, there is a button called "Format Painter"; click that.
    Go to sheet 2.
    Select all cells that will need the same formatting.
    DONE. Once these cells are selected, it copys/pastes the conditional formatting from sheet 1 to them.

    NOTE: The layout of Sheet 1 and Sheet 2 will need to be identical for this to work properly, meaning you have all the same column/row headings in the same order (or your information will be mis-ruled).

    Hope this helps others!
    Last edited by blizz; 04-07-2011 at 09:00 AM. Reason: [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