For example, if the formula for an item in your dropdown list calculates the number 90 or above, then the cell background color could become green when the item is selected from the dropdown list.

Q. How do I create a drop-down list to include in my spreadsheet? A. Creating drop-down lists in your spreadsheets is a great way to ensure that only certain information is entered into a cell.For ...