conditional formatting issues

Anonymous
2020-12-13T12:46:40+00:00

When I use a conditional format, then filter the data, excel seems to retain the momory of the highest row number filtered e.g. row 53000, so if later the filtered range is only 20 rows, it will still filter 53000 rows in displaying the range I need to see. Does anyone else have this issue?

Microsoft 365 and Office | Excel | For home | 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

5 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-12-16T06:59:37+00:00

    Ok i will upload it.

    Thank you. I'll be patient for your reply.

    If you have issues with OneDrive please check out this article:

    Share OneDrive files and folders - Office Support

    Andreas.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-12-15T17:00:16+00:00

    Ok i will upload it.

    Thanks

    Was this answer helpful?

    0 comments
  3. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-12-13T14:04:57+00:00

    Stella,

    please, we need to see your sample file.

    Andreas.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-12-13T13:13:28+00:00

    Thanks Andreas.

    It’s a problem I’ve been experiencing for years, and the only way I can get around it temporarily is to re-do everything in a brand-new sheet.

    I’m just wondering if there’s a way around it

    Was this answer helpful?

    0 comments
  5. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-12-13T13:05:05+00:00

    That is very difficult to answer because a lot depends on how your data is structured, how you applied your filter and of course the details of the conditional formatting.

    Therefore I suggest that you try to recreate that in a new file with e.g. 500 rows of data (number from 1 to 500 in column A is enough).

    If the issue persists:

    Login to https://onedrive.live.com (Use the same Login ID and password as for this forum).

    Click Upload in the top and choose your file.

    After uploading, right click the file and choose Share.

    Click Copy Link in the lower left edge (no need to enter an email).

    Copy the link and paste it here.

    Andreas.

    Was this answer helpful?

    0 comments