dabug80
asked on
Excel: Hide Multiple Row Selections Based on Other Cell Value
Hello,
Attached is a spreadsheet with 2 sheets. On the trigger sheet, when the value of a yellow cell is yes, I would like the corresponding coloured rows on the 'rows to hide' sheet to become hidden. I would also like the image set atop the rows to be hidden.
Also for the opposite, if the value is no longer Yes, the rows are to be unhidden and the image is to be visible.
Is it possible to easily embed images within cells so they can move up/down and be hidden with cells?
Thanks for your help.
Hide-Rows.xlsx
Attached is a spreadsheet with 2 sheets. On the trigger sheet, when the value of a yellow cell is yes, I would like the corresponding coloured rows on the 'rows to hide' sheet to become hidden. I would also like the image set atop the rows to be hidden.
Also for the opposite, if the value is no longer Yes, the rows are to be unhidden and the image is to be visible.
Is it possible to easily embed images within cells so they can move up/down and be hidden with cells?
Thanks for your help.
Hide-Rows.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent. Works well, thanks
You're welcome.
-Glenn
-Glenn
That will allow the graphics to be hidden/shown along with the rows.
Regarding your main question: do you want to show/hide the specific rows in this example or ANY colored rows on that sheet?
So either:
Red = rows 6:11
Yellow = rows 14:20
Green = rows 23:29
-or-
Any Red, Yellow, or Green rows.
Regards,
-Glenn