How to conditionally format based on sum of children?

M. Blackburn

I currently have a meeting agenda sheet. In the parent row for the meeting I'm calculating how many meetings have been reserved for the meeting versus how many have been put on as agenda items. In the parent row I have a formula:

="60 minutes have been reserved for the meeting and " + SUM(CHILDREN()) + " minutes have been put on the agenda."

How could I maybe just put "60" in the parent cell indicating the total number of minutes, and then use condititional formatting so that IF the sum of the children agenda minutes requested is greater than the time alloted for the meeting it would flag the parent "60" to give me a visual indicator the agenda is already over time?

Paul Newcome

I would insert a helper column (flag type that can be hidden after setting up) and then use this formula:

=IF(VALUE(LEFT([Text String Column Name]@row, FIND(" ", [Text String Column Name]@row) - 1))< SUM(CHILDREN([Minutes Column Name]@row)), 1)

Then you can set up your conditional formatting based on this new column being flagged.

Paul Newcome

I would insert a helper column (flag type that can be hidden after setting up) and then use this formula:

=IF(VALUE(LEFT([Text String Column Name]@row, FIND(" ", [Text String Column Name]@row) - 1))< SUM(CHILDREN([Minutes Column Name]@row)), 1)

Then you can set up your conditional formatting based on this new column being flagged.