Forum Discussion
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
- Anonymous4 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
- AnonymousNot 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
- AnonymousNot applicable
HI Anonymous,
Thank you for sharing the solution, I think it will be helpful if others faced similar scenarios.
Regards,
Xiaoxin Sheng