Setting a default format with Parent/Child Rows

Justin Cimino

Hello,

Is it supported to set a default format for parent/child rows? For example, when a row becomes a parent, automatically

• set text to bold
• set text size == 16
• set the row background color to gray and
• set the text to white.

Thank you,

Justin

J. Craig Williams

1. Add a Checkbox column with this formula

=IF(COUNT(CHILDREN([Primary Column]23))>0,1,0)

for your Primary Column (change to your column name) and row 23 (then copy to the rest of the column)

This will be checked when the row has children.

2. Then set up Conditional Formatting for when the Checkbox is checked.

Craig

Andrée Starå

Craig beat me to it!

Hi Justin,

Yes this is possible with with some conditional formatting and som other tricks.

I'll get back later and write how it's accomplished.

Best,

Andrée

Justin Cimino

Thank you Craig!

Justin Cimino

Thank you.