Re: Toggle Conditional Formatting On/Off
Thank you Dave, but I don't think I understand how/where to do what you suggest.
Because I'm using a top10 condition, I don't know a way to add to the condition. There is obviously no place through the interface and when I examine the coded format conditions, I see no place to add my own terms to the conditions - everything appears to be defined by setting object attributes to system constants.
Will your solution effectively eliminate the de-selected rows from the calculation? It's not just a matter of not formatting the deselected rows, I also can't have the values of the deselected rows affect formatting of the selected rows. (For example, if I'm highlighting the top 50% of values and have 20 rows selected, I want to highlight the top 10 rows. If I deselect those 10 rows, I want conditional formatting to highlight the next 5 values (top half of 10 selected rows)).