Now, let’s make the check mark green so it’s a bit clearer when a task is completed. Select the C column, and go to Format , Conditional formatting , + Add another rule again.

For more Excel tips, check out 56 Excel tips every user should master.) In both cases below, you’ll need to open the Google Sheet you want to edit and select the cell (or cells) you want to modify.