With Microsoft Excel ... list instead of entering data. You can further tailor the spreadsheet by using conditional formatting to fill the cell with a specific color depending on which list ...

Excel's conditional formatting tool applies formatting depending on cells' contents. Validation rules can change cells font, style, size or border. They can also change the text's color.