copying conditional formatting

Discussion in 'Microsoft Excel Worksheet Functions' started by Guest, Dec 23, 2004.

  1. Guest

    Guest Guest

    I'm doing an analysis of extensive data, and have setup conditional
    formatting to display the results. Is there a way to copy the conditional
    formatting to the entire range of data? I have it setup in one cell, but
    when I copy it to the other cells in the column (either using Paste Special
    or the Paintbrush), it references the original cell. Do I have to manually
    adjust each cell (approx 450) or is there a shortcut?
     
    Guest, Dec 23, 2004
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Yes, you can copy it for instance by using the format painter paintbrush,
    note to be able to copy the formattin the cell reference must be relative

    If for instance you would use

    =$A$2>5

    in your formatting and you want to copy that down, you must remove at least
    one dollar sign, either

    =$A2>5

    or

    =A2>5

    if you do that you can just right click on the cell, copy down and select
    fill formatting or using the format painter

    Regards,

    Peo Sjoblom

    "Jakgeem" wrote:

    > I'm doing an analysis of extensive data, and have setup conditional
    > formatting to display the results. Is there a way to copy the conditional
    > formatting to the entire range of data? I have it setup in one cell, but
    > when I copy it to the other cells in the column (either using Paste Special
    > or the Paintbrush), it references the original cell. Do I have to manually
    > adjust each cell (approx 450) or is there a shortcut?
     
    Guest, Dec 23, 2004
    #2
    1. Advertisements

  3. Guest

    Guest Guest

    Thanks!

    "Peo Sjoblom" wrote:

    > Yes, you can copy it for instance by using the format painter paintbrush,
    > note to be able to copy the formattin the cell reference must be relative
    >
    > If for instance you would use
    >
    > =$A$2>5
    >
    > in your formatting and you want to copy that down, you must remove at least
    > one dollar sign, either
    >
    > =$A2>5
    >
    > or
    >
    > =A2>5
    >
    > if you do that you can just right click on the cell, copy down and select
    > fill formatting or using the format painter
    >
    > Regards,
    >
    > Peo Sjoblom
    >
    > "Jakgeem" wrote:
    >
    > > I'm doing an analysis of extensive data, and have setup conditional
    > > formatting to display the results. Is there a way to copy the conditional
    > > formatting to the entire range of data? I have it setup in one cell, but
    > > when I copy it to the other cells in the column (either using Paste Special
    > > or the Paintbrush), it references the original cell. Do I have to manually
    > > adjust each cell (approx 450) or is there a shortcut?
     
    Guest, Dec 23, 2004
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Norman Harker

    Re: Problems using conditional formatting/copying formatting

    Norman Harker, Aug 5, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    356
    Norman Harker
    Aug 5, 2003
  2. Cindy

    Copying Conditional Formatting

    Cindy, Jul 21, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    211
    macropod
    Jul 21, 2004
  3. Guest

    COPYING CONDITIONAL FORMATTING TO A COLUMN

    Guest, Nov 1, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    142
    Gord Dibben
    Nov 1, 2004
  4. Guest

    Copying conditional formatting...HELP PLEASE!!!!

    Guest, Mar 21, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    157
    Guest
    Mar 24, 2005
  5. Greegan

    Conditional Formatting - Can I select a select with Conditional Formatting?

    Greegan, Oct 30, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    5
    Views:
    492
Loading...

Share This Page