Share via

Excel filtering wrong cells

Anonymous
2017-05-10T11:03:53+00:00

Hi

 I have created this conditional formatting for my data as shown above. I want to filter it so I only see the data with one color as shown below:

When I make this filter only the light red cells should remain. However, when I filter like this the results come up wrong where some cells, which are not light red are still included, as shown below:

Have any of you experienced this problem? It is not because the conditional formatting changes, I have checked. Hope you can help :)

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-05-10T18:03:55+00:00

    I am sure you would have thoroughly checked your conditional formatting formulas/conditions.

    However, it appears that somewhere there is an over lap of conditions wherein for those green and red colored cells, both (pink + green  and pink + red) the conditions are getting satisfied.

    0 comments