Based on a cell value = true or false, I conditionally formatted rows to turn black. That means that I need to scroll down to find the set of rows that did not turn black. I would prefer that all my rows with data remain unexpanded and remain hidden and only expand when cell value = true. Is there a way to unhide the few, select rows when the cell value = true and compress/hide if cell value=false - without using macros; or any macro code suggestion if one is needed. This will forego the scrolling.
No comments:
Post a Comment