Share via

How to maintain cell highlight colors when sorting using the filter function ?

Anonymous
2024-01-03T16:13:15+00:00

When using a filter to do different sorts of rows in a spreadsheet, if the rows are highlighted with a color, the color is not maintained after the rows are sorted. See attached screen cap. I am using the most recent version of Excel, but I've had this ongoing issue for a while in diff versions of Excel. My understanding is when sorting using a filter all of the the data and formatting for each row should be maintained after being sorted.

Appreciate some guidance. Thanks.

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-01-04T02:05:50+00:00

    Thanks, will try that. Kind of a hassle

    to have to set up new rules

    highlight colors when sorting using

    using online sql :

    //cli_no_header;

    create temp table aa as

    select * from sheet1 order by f01;

    cli_mark_duplicate_rows~aa~f04;

    for a simple sort function, but will give it a go and see how it works.

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2024-01-03T20:10:56+00:00

    Thanks, will try that. Kind of a hassle to have to set up new rules for a simple sort function, but will give it a go and see how it works.

    1 person found this answer helpful.
    0 comments
  3. Anonymous
    2024-01-03T16:20:30+00:00

    If you want to keep the color fill, you may try conditional formatting.

    =ROW(A2)<11

    =ROW(A2)<21

    =ROW(A2)<31

    When I sort the column C, the color fill will keep.

    If my understanding above is not consistent with yours, share us a test file and expected result.

    0 comments