+ Reply to Thread
Results 1 to 3 of 3

Copy Conditional Format only without over writing existing format

  1. #1
    Registered User
    Join Date
    11-20-2012
    Location
    Beccles, Suffolk
    MS-Off Ver
    Excel 2010
    Posts
    5

    Copy Conditional Format only without over writing existing format

    Hi

    I have a spreadsheet that has values in many different numerical formats. However I wish to copy a conditional format from one cell to the rest of the spreadsheet without changing the number formats.

    Is it possible to copy a conditional format only without changing any other formatting?

    Many thanks for your help in advance.

    Rob
    Last edited by RobNorwichUK; 01-22-2013 at 12:21 PM.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,675

    Re: Copy Conditional Format only without over writing existing format

    No, but it's very easy to edit the "Applies To" range of the rule from the one cell to include other/all cells. Have you looked at that?
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-20-2012
    Location
    Beccles, Suffolk
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Copy Conditional Format only without over writing existing format

    Hi

    Yes, this works for me.

    Thanks for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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