Make Automatically Color Coded Lists in Google Sheets

Posted by in Google Drive

Conditional formatting is one of the most powerful features of Google Sheets, and can be used for some pretty clever functions. In this tutorial we will create an automatically color coded spreadsheet with a column that changes cell color based on the different values entered.

1. Create a new spreadsheet and type some sample data. For this example let’s make a column of several repeating names.

We also entered ‘Nobody’ and ’12’ to test that it does not color code any incorrect values.

2. Select the entire column and go to Format > Conditional Formatting

3. For “Format Cells If..” choose “text contains.”

Type the text that you want to automatically turn colors. In this case we’ll use names.

4. Instead of clicking ‘Done’ click ‘Add Another Rule’

and define the colors for other names/phrases that you will be using.

5. You’ll see that the cells with the corresponding text are now automatically color coded.

As you add new names to the list, they will color code themselves after you hit enter or return.