+ Reply to Thread
Results 1 to 8 of 8

Sorting data that is a mix of cell formatting

  1. #1
    Registered User
    Join Date
    10-28-2018
    Location
    South Australia
    MS-Off Ver
    2010
    Posts
    25

    Sorting data that is a mix of cell formatting

    I have spreadsheets that I sort on a certain column but the range is a mix of not only data but cell formatting such as fill colours & cell borders.
    Now while the cells with fill colours all goes well & the majority of cells have basic borders but some have larger colour borders and these borders do not move with the specific cells that they are around.
    Is there a method of having such defined borders move with cells upon data sort?

    Ron
    Last edited by Mabocat; 09-25-2019 at 07:51 PM. Reason: spelling correction

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: Sorting data that is a mix of cell formatting

    Short answer, I would say no. You are applying formatting to the cell, so the formatting stays with the cell, but the cell contents move when you sort them.

    If there is some logic to why the extra formatting is applied, we may be able to come up with some Conditional Formatting to help you?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-28-2018
    Location
    South Australia
    MS-Off Ver
    2010
    Posts
    25

    Re: Sorting data that is a mix of cell formatting

    Thank you.

    The specific formatting is to highlight to users of the spreadsheet certain data & notes. It is interesting that fill info, a colour, moves with the cell data though.

    Ron

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,108

    Re: Sorting data that is a mix of cell formatting

    Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

  5. #5
    Registered User
    Join Date
    10-28-2018
    Location
    South Australia
    MS-Off Ver
    2010
    Posts
    25

    Re: Sorting data that is a mix of cell formatting

    Quote Originally Posted by FDibbins View Post
    Can you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    OK, when I know how to attach a file & it gets done. so re-sort it using column A and see the cell K11 border does not follow the cell data

    Ron

  6. #6
    Registered User
    Join Date
    10-28-2018
    Location
    South Australia
    MS-Off Ver
    2010
    Posts
    25

    Re: Sorting data that is a mix of cell formatting

    I think I found how to upload an attachment but now adding it to this thread ? but clicking on the attachment icon just gives me small box so I don't know how to select it?

    all good so it seems once I previewed the thread

    Ron
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    09-23-2011
    Location
    UAE
    MS-Off Ver
    Excel 2019
    Posts
    29

    Re: Sorting data that is a mix of cell formatting

    Quote Originally Posted by Mabocat View Post
    OK, when I know how to attach a file & it gets done. so re-sort it using column A and see the cell K11 border does not follow the cell data

    Ron
    Can you see the attached? is this how you want it done? It is conditional formatting.

    I couldnt do the thick red border, but if it is for visual purposes only maybe the same white font over a red background would do.
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    10-28-2018
    Location
    South Australia
    MS-Off Ver
    2010
    Posts
    25

    Re: Sorting data that is a mix of cell formatting

    Thank you, that is what I read elsewhere about conditional formatting - yes for visual purposes only so i will do a different fill colour & font.

    Ron

+ 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. Conditional Formatting or Data Validation for 1 cell based on another but limited data?
    By ExcelBeginner326 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-10-2015, 01:25 PM
  2. Replies: 1
    Last Post: 01-20-2014, 03:52 AM
  3. Replies: 1
    Last Post: 07-02-2013, 07:57 AM
  4. auto fill data in one cell based on formatting of another cell
    By ashouse in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-21-2013, 04:48 PM
  5. Replies: 0
    Last Post: 08-29-2012, 09:24 AM
  6. cell colours for every 15th cell with data (condition formatting and Macro)
    By eastydie in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-09-2012, 04:57 AM
  7. Sotring Data and Frequency of Entries
    By DaleJay in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-12-2009, 12:14 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