Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Conditional formatting doesn't work properly when filtering a table

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's avatar
    Anonymous
    4 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      HI Anonymous,

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

      Regards,

      Xiaoxin Sheng