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