+ Reply to Thread
Results 1 to 5 of 5

How to copy format to sorted cells only?

  1. #1
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    How to copy format to sorted cells only?

    The cells at column A are first sorted for valued cells only.
    As format of cells (Cell A7) is copied to valued cells at column A under sorting,
    the unsorted cells are also formatted as attached file.

    How to copy format to other cells under sorting, without copying format to unsorted cell?
    (as shown in expected results in column B)

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: How to copy format to sorted cells only?

    Try:
    * Advance Filter, unselect blank cells, then format
    Or
    * Format all first, then advance filter, choose blank only, then format no colour
    Quang PT

  3. #3
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to copy format to sorted cells only?

    I want to copy the format of cells A7 to sorted cells;
    instead of formatting from the beginning;

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: How to copy format to sorted cells only?

    Try these steps:
    * AdvanceFilter/ Deselect blanks
    * Copy B7
    *Select sorted area
    * Ctrl-G (Goto)/ Special/Visible cells only/OK
    *Paste Special/Format/OK

  5. #5
    Forum Contributor
    Join Date
    09-18-2011
    Location
    Hong Kong
    MS-Off Ver
    Office 365
    Posts
    375

    Re: How to copy format to sorted cells only?

    Thanks bebo021999.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extract a non-sorted list with blank cells into a sorted list
    By RJK in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-08-2015, 12:41 AM
  2. [SOLVED] How do I copy data to end tab and have it appear sorted?
    By Mae Stoll in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-04-2015, 03:37 PM
  3. copy abbreviated format add a , add a cells value and paste to only blank cells
    By kleptilian in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-23-2014, 02:26 PM
  4. [SOLVED] Sorted copy of a table
    By laszlo.kocsis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2012, 04:02 AM
  5. copy conditional format to several cells using formulas with relative cells
    By jhowell01 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-05-2012, 12:16 AM
  6. How to copy cells from one sorted list to another
    By excel-novice-2010 in forum Excel General
    Replies: 1
    Last Post: 09-06-2010, 04:02 PM
  7. [SOLVED] Copy Sorted Coloumn
    By Pete in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-10-2006, 05:30 PM

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