Check box to clear formatting

Esperanza Zagal

Done to clear formating.PNG

Hello,

I want to make it so that once done is selected, it clears formatting. I tried doing this via conditional formatting but the clear format (white with black text) makes the condition appear incomplete. Is the only way around this to change the default format of the rows?

Thank you,

Esperanza

Andrée Starå

Hi Esperanza,

I’d recommend setting the formatting options in Conditional Formatting.

Keep in mind that the Conditional Formatting prioritizes the rules from top to bottom, so maybe that is the reason why you're not getting the desired result.

Make sense?

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

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