Auto-formatting on New Rows

monica16145

I'm trying to build a collaborative sheet for my team, but every time someone adds a new row, the formatting from the (January, February, etc.) parent rows applies to the new row. Is there a way to turn this auto formatting off so all new rows entered into the sheet are standard white rows with 10 pt black text?

JamesB

@monica16145 You could create a helper column with a =Count(Ancestors()) formula as a column formula, then use Conditional Formatting to format rows based on the number in the result.

With this formula, a top level row would =0 because it has no ancestors, the first child would =1, the child below that =2, and so on.

monica16145

Neat! This worked pretty well but for some reason the italics, size 12 font, and bold formats are still carrying over. (everything except the blue background color). I set up the conditional formatting like this:

If "Helper Column" is not 0 then apply this format to entire row.

Any idea why its doing this? Thanks

Andrée Starå

Hi @monica16145

I hope you're well and safe!

Ensure you're changing all the formatting settings set by other rules or manually in the sheet.

Make sense?

Did that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

monica16145

Hi Andrée, I do not have any other formats set in the sheet that would compete with this one. What do you mean by manually changing?

Andrée Starå

@monica16145

With manual, I mean the ones that you change the format manually, and that format will show if you don't select something instead of it in the rule.

Make sense?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

JamesB

@monica16145 Also note that formatting rules apply in order from top to bottom. So 1 rule could cancel out another. You may need to reorder your rules.