How to implement dropdown with further properties to compute

Getting help Questions
1

Using following code, I was able to implement dropdown on certain rows and columns

 hot1.updateSettings({
     cells: function (row, col, prop) {
         var cellProperties = {};
         if (row === 7 && (col >= 3 && col <= 8)) {
             cellProperties.type = 'autocomplete';
             cellProperties.source = ['yellow', 'red', 'orange', 'green', 'blue', 'gray', 'black', 'white'];
             strict: true;
         }

How to implement further calculation?
For example, if red is selected, somewhere to multiple value 100, green with value 80, etc.

2

Hi @twcloudwebapp
I think that your seeking dependencies between cells, right? If so take a quick look at our blog post https://handsontable.com/blog/articles/expand-your-app-with-cell-dependencies
You can find there how to set dependencies between cells.