<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - CALC: Dynamic conditional colour formatting in autofiltered arrays" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138478#c7">Comment # 7</a> on <a class="bz_bug_link bz_status_NEEDINFO " title="NEEDINFO - CALC: Dynamic conditional colour formatting in autofiltered arrays" href="https://bugs.documentfoundation.org/show_bug.cgi?id=138478">bug 138478</a> from <a class="email" href="mailto:that.man.colin@gmail.com" title="Colin <that.man.colin@gmail.com>"> Colin</a> <pre>(In reply to Heiko Tietze from <a href="show_bug.cgi?id=138478#c6">comment #6</a>) > Probably a misconception. Let's take a simple example > > Group Value > 1 1 > 1 1 > 1 2 > 2 2 > 2 3 > 2 3 > > If you apply the color scale to value 1 becomes green, 2 yellow, and 3 red. > If you copy the group 1 and apply the same color scale you don't have the > full range and 2 becomes red. > > Without having read the initial request: doing the calculation based on the > current filter makes absolutely no sense. A filter is not a subset. Precisely the substance of the request. The implication is that the boundaries are set by the original group and it would be nice if there were some mechanism by which the boundaries could be changed by the selection of a subset to reflect the new highs & lows extant in the subset. I think what you're saying is - Not possible/desirable/logical via the auto-filter/SUBTOTAL() mechanism and that a user would have to copy and paste special the data and then re-define the conditional colour spectrum for each and every iteration of paste special.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>