Updating cells based selection drop down list data validation
For a star rating, you can use "★★★★★,★★★★,★★★,★★,★" in the Source field.This example comes from the Feature Comparison template.In this article, we will use INDIRECT function to get the output.INDIRECT: Returns the reference specified by a text string.The font used in the drop-down list cannot be changed, so it is always just a black sans serif font.
Following is a snapshot of Jan Month data In summary sheet, the formula would be =Jan!This approach is great for simple Yes/No options and other lists that appear only once in your spreadsheet.The problem with this approach is that if you use this in a lot of cells and later want to update the list, you have to update all cells that use the list and there is a good chance you'll miss one.Usually, you will use absolute references like $C:$C for the Source in your drop-down list.However, there may be times when you want the drop-down Source to change when you copy and paste the cell.
Search for updating cells based selection drop down list data validation:
) need to be replaced with “&B1&” Now the formula becomes =INDIRECT(“”&B1&”!