Create an interactive task list

Conditional Formatting in Google Sheets

Adam Steinfurth

Instructor

Write your list

Done?	Task
	Make your bed

Finish your list

Done?	Task
	Make your bed
	20 minutes of focused reading

Now you're done

Done?	Task
	Make your bed
	20 minutes of focused reading
	Half hour of meditation
	100 pushups, 20 pullups, 100 situps

Insert checkbox

Checkbox

All checkboxes inserted

Custom formula

=A4=TRUE

Strikethrough

Gray highlighting

Finished task list

Let's go practice!

Conditional Formatting in Google Sheets