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.

How to count individual cells within a row by their fill color in Excel Your email has been sent The article How to easily sum values by a cell’s background color in Excel shows you an easy way ...