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.
Subscribe to:
Post Comments (Atom)
How can I VLOOKUP in multiple Excel documents?
I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...
-
I'm working on some .bat stuff created in a legacy application, which uses many environment variables. I need to know exactly what is e...
-
Is it possible to use the tablet style on-screen keyboard on a Windows 8 laptop PC? I've found the 'Ease of Access' version whic...
-
On my desktop there are a sea of icons and I realy like ability to hide them. I can do that if do right click on desktop and find arrange ic...
No comments:
Post a Comment