Hi all,
I have a sheet that i have been using for the past year and all of a sudden it seems something is wonky. I have parent and child rows that I can expand and collapse. I have conditional formatting on the parent to change colors when a child is present.
I cannot remember how I made it work, but all of a sudden it is no longer changing colors. My conditional formatting looks a helper column to determine color. That helper column has no formula (anymore?) It seems like something may have been setting that column to a value because its a hidden column.
Is there any way to search history to see when it changed or what it was? OR how can I create a function to set the column level of the parent row?
Hope that makes sense.
Thanks.
Pam
