Highlight a specific cell not the entire column/row

Ryan Jared

I'm looking to only have child rows highlighted when the value is greater than one. Currently conditional formatting only allows for applying a format to an entire row, or to all the cells within a column (Parent + Child) are there any formulas I can embed in a child row cell that will only highlight for that specific cell?

Paul Newcome

You would need a helper column (can be hidden after setting up to keep the sheet clean). I would suggest a checkbox with the following column formula:

=IF(COUNT(CHILDREN([Column name Of Choice]@row)) = 0, 1)

This will automatically check the boxes on all child rows. You would then include this as one of the criteria in your conditional formatting rule.

Paul Newcome

You would need a helper column (can be hidden after setting up to keep the sheet clean). I would suggest a checkbox with the following column formula:

=IF(COUNT(CHILDREN([Column name Of Choice]@row)) = 0, 1)

This will automatically check the boxes on all child rows. You would then include this as one of the criteria in your conditional formatting rule.

Ryan Jared

That worked our quite well, thanks so much Paul!

Paul Newcome

Happy to help. 👍️