
Format Hierarchy Levels

We’ll demonstrate how to format your hierarchy levels automatically.
As a trainer and consultant I see a lot of client work and often clients, who are unaware of the power of hidden helper columns, end up formatting their parent rows manually. This is not only time consuming but also can lead to formatting errors when the hierarchy changes.
Conditional formatting is great, but without columns that help you identify the rows you’d like to format it can be tricky to set the right rule within the tool, often with people giving up and they don’t know how to set the fact that it’s a top level parent as a rule.
I have worked with my team to create a short video to demonstrate the power of hidden columns to help identify the rows to format, as this weeks Top Tip Tuesday.
It’s the first video powered tip – let us know what you think and whether you’d like more tips explained in video format.












