Hi Caleb,

Sure, there are multiple ways to do this.

**METHOD 1: Cell-level formulas**

You can write cell-level formulas to test whether a row has a parent or children, and then copy those formulas into each row where you need to calculate this.

To test if a row has a parent, you can write a formula like:

`=IF(PARENTCELL(A2)="",FALSE,TRUE)`

To test if a row has one or more children, you can write a formula like:

`=IF(COUNTA(CHILDCELLS(A2))>0,TRUE,FALSE)`

You can then apply these same formulas in other cells within your column, resulting in something like this, which you could then set up conditional formatting on:

**METHOD 2: Column formula columns**

A perhaps easier solution is to use a Column Formula.

To create a Column Formula column to test if a row has a parent, your column formula could be written as shown here:

To create a Column Formula column to test if a row has children, your column formula could be written as shown here:

So the result would look like this, which you could then set up conditional formatting on: