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...
Need Help
  • 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

Anonymous's avatar
Anonymous
Not applicable
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    HI Anonymous,

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

    Regards,

    Xiaoxin Sheng