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:

updating cells based selection drop down list data validation-21updating cells based selection drop down list data validation-31

) need to be replaced with “&B1&” Now the formula becomes =INDIRECT(“”&B1&”!

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “updating cells based selection drop down list data validation”

  1. Backdating could be accomplished either at the time of the grant, by arbitrarily selecting an earlier date when the stocks price was lower, or after the grant has been made, by retroactively changing the grant date.