robertomd
New Member
Hello,
If we have a table with a column of values that have a conditional formatting relative to those values (e.g. red cell for the highest value of the column, green cell for the lowest), and then we filter this list so one of these values is filtered (hidden), the conditional formatting still aplies to ALL the range, instead to the visible range of cells. In this exemple, the red cell is hidden.
Is there a way to change this behaviour, so if the highest value is filtered, I can see a red cell for the highest of the still visible, non filtered, values?
Thanks in advance
If we have a table with a column of values that have a conditional formatting relative to those values (e.g. red cell for the highest value of the column, green cell for the lowest), and then we filter this list so one of these values is filtered (hidden), the conditional formatting still aplies to ALL the range, instead to the visible range of cells. In this exemple, the red cell is hidden.
Is there a way to change this behaviour, so if the highest value is filtered, I can see a red cell for the highest of the still visible, non filtered, values?
Thanks in advance