John Darby
asked on
Excel color cell by level of indent
Greetings,
I am seeking to color cells in a column by the level of indent. Would you be able to shoot me in the right direction to accomplish this?
Thank you, in-advance!
JohnD
I am seeking to color cells in a column by the level of indent. Would you be able to shoot me in the right direction to accomplish this?
Thank you, in-advance!
JohnD
I'd need to see the workbook.
Or at least a workbook that contains a sheet with "indented" data.
ASKER
Thank you,
Here is the column I am seeking to add color per level of indent
Here is the column I am seeking to add color per level of indent
No attachment.
ASKER
Trying again :)
indent.xlsx
indent.xlsx
Okay do you want to use coloring similar to the black and gray you have now?
ASKER
That would be great...I am mostly not wanbting to present a bunch of saturated colors which shock consumers :)
Thank you!
Thank you!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Martin,
silly me...how do you "apply" the macro? I have it in the VB Explorer, inserted into the editor
silly me...how do you "apply" the macro? I have it in the VB Explorer, inserted into the editor
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
silly me...how do you "apply" the macro? I have it in the VB Explorer, inserted into the editorOpen Excel
Alt+F11
Choose Insert->Module from the menu
Copy my code to the module
If you want to assign a Shortcut Key
Go back to the sheet view
Select the Developer tab
Select Macros from the menu
Select the macro
Click Options...
ASKER
Thanks FarWest!
Martin,
thank you! I ran the Debug and it executed the instructions against the page...thanks again!
Martin,
thank you! I ran the Debug and it executed the instructions against the page...thanks again!
ASKER
Thank you!
You're welcome and I'm glad I was able to help.
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2014
ASKER
Thanks Marty!