Set up progress trackers: Open Sheets and select the column that you want to apply the formatting rules to. Select Format. Conditional formatting. Set up the rules. In this example, you assign a different color to tasks that are Complete, Not started, or In progress: