Conditional formatting doesn't work properly when filtering a table

[Anonymous]

Hi everyone,

I have a table where I set conditional formatting for a column, based on another column.

This works properly, unless I filter the table.

Here we can see that nothing is colored in the 'PR ID' (bottom table) column, as it should be:

But when I click on the above table on Tag 22.2.28.1 for example, this is what happens:

They should not be colored ..

Any idea on why is this happening?

The conditional formatting is a sum of another column which is basically 0 or 1 where 0 is white and 1 is yellow ('Sum' of that column).

Thanks

[Anonymous · Accepted solution]

Okay I manages to solve this.. 

The problem was that the conditional formatting was set automatically to highest and lowest value instead of being simply 0 and 1. 

thanks

[v-shex-msft]

HI @Anonymous,

Thank you for sharing the solution, I think it will be helpful if others faced similar scenarios.

Regards,

Xiaoxin Sheng