Microsoft Excel Question

Discussion in 'Off The Beaten Track' started by Flatfoote, Sep 27, 2011.

  1. Flatfoote

    Flatfoote Active Member

    680
    106
    43
    Calling all Excel Experts!

    My question is about Excel. I use a "conditional formatting" in a workbook, where one part of one column has the conditional formatting I want. And it's duplicated on each of the 20+ sheets I have in the workbook (plus I use the same formatting on 3 other workbooks as well).

    I'm assuming there is a way to save that conditional formatting command, so all I have to do is call it up and transfer it to each sheet's column. It's just a little tedious to enter it each time, since it involves three conditions with formatting of each condition.

    I think I researched it once, and I think I read mention of macros? To this day, I have no idea what a macro is, how to create one, or how to use one. I do know that sometimes I'd get a prompt saying the workbook I was opening is using macros, which could be harmful, and did I want to continue. I don't even know why a macro would be harmful. But I know that since most of what I know about Excel is self-taught (and asking questions of people like the experts here), I've probably avoided learning about macros cause of those prompts I used to get.

    So, if the answer is "create a macro." Then, well, you're gonna have to take me through it step-by-step, and treat me like I'm a complete idiot (which I probably am). Not only will I need to know how to create it, I'll need to know how to use it.

    I'm hoping there's a much simpler solution that what I'm fearing. LOL.
     
  2. Erica Lee

    Erica Lee New Member

    2,146
    304
    0
    I'm not sure if this will work, because I don't have a spreadsheet handy to test it out - but give it a try and see:

    Highlight a/some cells with the formatting you want, and copy it.
    Highlight the cells that you want to have this formatting, then go to Edit --> Paste Special --> Paste Formats
     
  3. Flatfoote

    Flatfoote Active Member

    680
    106
    43
    Hey cool! I think that works! I was able to get it to work within the same workbook, but I couldn't get it to transfer over to a second workbook, cause when I clicked "paste special" a different looking window pops up that doesn't give a Paste Formats option. But that's ok, cause each workbook already has at least one sheet with the conditional formatting I want in it, so I can just start there. I'll also have to make sure to highlight the entire field that I want to copy, rather than just a few random cells, seeing as it also transferred over the borders.

    Thank you for your help!!
     
  4. Erica Lee

    Erica Lee New Member

    2,146
    304
    0
    Glad it worked! You're very welcome!