Formatting Parent Rows

Is it possible to format a parent row based on the number of children rows under it? If so, could you take it one step further saying like, highlight the parent row green if there are no children rows, yellow if 1 and red if 2. etc

Thanks

Find more posts tagged with

IT & Operations

Conditional Formatting

Comments

Marcus Odum

Yes this is possible, but it requires the use of an aditional column. I leverage parent formatting for my projects.

Example: If the row is a parent row make it bold

create a checkbox column and name it vParent (lock it)
Enter: =COUNT(CHILDREN())
Enter a formatting condition that addresses your criteria

If the vParent is 0 then green, 1 yellow, etc.