Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2022-07-19 12:59:48 | ![]() 8,155 Views |
——————————————————————————————————————————————————
– Free check of your Excel Skill Level- https://excel-skills-assessment.com/skills-assessment/
– Test employee Excel skill levels- https://excel-skills-assessment.com/excel-skills-test-for-employment/
– Improve you Excel Skill Levels- https://online-excel-training.auditexcel.co.za/course-category/skill-based-beg-int-adv/
– Our main website- https://www.auditexcel.co.za/blogs/
——————————————————————————————————————————————————
Time Stamps
00:00 Extract the indent level in Excel cells
00:17 Are indents spaces or actual indents?
00:44 Get the indent level on a single cell
01:28 Indent level on all cells without using VBA
01:55 Using FIND to identify cells with the same indentation level
02:08 FIND the format within a cell with indentation of 2 levels
02:41 List all the cells with level 2 indentation
02:49 Color all the cells with the same indentation level the same color
03:12 Do another find on ALL cells for next indent level
03:45 Color all level 6 indents with a different color
04:15 WARNING- Correct the FIND tool before you proceed
05:20 Put the indent level number in a cell based on matching colors
06:17 VBA can be used
Please take the opportunity to connect and share this video with your friends and family if you find it useful.