Indenting

Jeffrey Ottem

<![endif]-->

I am trying to format cells in a budget and I would like to indent the text below certain categories. For instance, in defining cabinets I have to identify the room, eg Kitchen, and then the various cabinets in the kitchen. I understand the parent/child relationship and how this works, however it doesn’t apply in this case because the entries can't be in the primary column (the only column I can see that indents) and also I don't want  them to be parent/child I just want them to be visually distinct from one another. Is there a way of formatting the text in a cell so that it isn't simply aligned to right, left or center?

Travis

Hi Jeffrey, sorry for the delay in a response! 

 

Do you want to format the parent row or child rows? Conditional formatting can be used to apply formatting to cells based on an aspect of that row. For example, you could use a formula to check the box of a checkbox column, if that row is a parent row, then set a formatting rule based on that checkbox. Is that what you are looking for?

 

Here is the formula that can be added to a checkbox column. Make sure you adjust [Task Name]21 to reference the primary column in the row. 

 

=IF(COUNT(CHILDREN([Task Name]21)) > 0, 1)